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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!