VLOOKUP matching text, referencing another sheet
I am trying to match a vendor name between two sheets and if it is found to display a risk rating from the other sheet. I am getting the error message #UNPARSEABLE with the formula below. What am I doing wrong?
=VLOOKUP("[Vendor Name]@row",{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2},false})
Sarah
Best Answer

I figured it out, no further help needed on this question.
Answers

I figured it out, no further help needed on this question.

I'm glad you figured it out!
For anyone else with a similar issue, it looks like Sarah had quotes around the cell reference "[Vendor Name]@row" which would need to be removed: [Vendor Name]@row
Additionally, it looks like there are two crosssheet references merged into one:
{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2}
which should look more like:
{Vendor Risk Rating Summary Range 1}
Here are some Help Articles that may help when building out formulas:
 Formulas: Reference Data from Other Sheets
 Create a Cell or Column Reference in a Formula
 VLOOKUP Function
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!