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 cross-sheet 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
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!