VLOOKUP from another SS Sheet

Al W
Al W
edited 12/09/19 in Smartsheet Basics

I am sure this is a simple formula, but I still find the Learning Pages quite vague an complicated for the person unfamiliar with formulas.

I have a sheet for Change Orders (Called "Change Orders"). I have a second sheet with Job Numbers (Auto Numbered) in the first column and Project Names in the second Column. This sheet is called Auto - Project Numbers.

My goal is to enter a Job Number in the Change Order Sheet and have it look up the job name from the Auto - Project Numbers to populate the Project Name in the Change Order sheet.

This is as far as I got:  =VLOOKUP({Auto - Project Numbers 2019 Range 1})

Thank you

Al W