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