VLOOKUP + Reference Another Sheet


I have been trying to VLOOKUP a value from Sheet A to a table in Sheet B and continue to get #UNPARSEABLE - here is the example I am working with and the formula:

  • =VLOOKUP([Primary Column]3, {test4 Range 1},3,false))

All columns are Text/Number format, the lookup value is in the left-most column. The VLOOKUP formula works when done in the same sheet, but once the table is reference to a separate sheet the error occurs. I literally copy/pasted the VLOOKUP example from the help center and still get the error referencing another sheet. Any ideas?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!