Vlookup with cross sheet reference

Options
Nathan Benn
Nathan Benn ✭✭✭
edited 12/09/19 in Formulas and Functions

Can someone please provide an example of the Vlookup formula with the cross reference?  I have tried both formulas below and get errors on both.

 

=VLOOKUP([New Job Code]1, {Lot Status Report - Goldmark Range 3}, {Lot Status Report - Goldmark Range 3}2, false)  #UNPARSEABLE

=VLOOKUP([New Job Code]1, {Lot Status Report - Goldmark Range 3}, 2, false) #INVALID REF

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!