Issues with Cross-Sheet Vlookup Formula
Options
Hello,
I've read a few posts about this but havent been able to solve. I'm trying to match a PO number to its job number which is listed in another sheet but get the 'Unparseable' error?
=VLOOKUP([PO Number]@row, {Temp - POsJob Nrs. Range 2}, 2, FALSE))
Any tips why this might be?
Answers
-
Try removing one of the closing parenthesis from the end.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!