VLOOKUP from another SS Sheet

Al W

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

 

Paul Newcome

In the Project Name column on the Change Order sheet, you would use something along the lines of...

 

=VLOOKUP([Job Number]@row, {Auto - Project Numbers 2019 Range 1}, 2, false)

 

Make sure your cross sheet reference range is both the job number column and the project name column from your auto numbers sheet.