Am I using the vlookup function correctly?
I'm using this formula
=VLOOKUP([LifePoint Group Facility]@row, {Facility Stakeholders Report - Anesthesia Range 1}, 14, false)
to lookup a recruiters name in another sheets. I keep getting a #nomatch.
What am i doing wrong?
Best Answer
-
Your VLOOKUP looks good. It will return the 1st value in the 14th column from the range selected in your other sheet where the 1st column is an exact match for the data in the "LifePoint Group Facility" column on the current row.
There are a few reasons why a match could not be found.
- Is the Facility name in the 1st column of the range you selected?
- Do the facility names match exactly?
If that doesn't help, can you share a screen shot of the 2nd sheet showing the full section that you have referenced and the value you expect to be returned?
Answers
-
Your VLOOKUP looks good. It will return the 1st value in the 14th column from the range selected in your other sheet where the 1st column is an exact match for the data in the "LifePoint Group Facility" column on the current row.
There are a few reasons why a match could not be found.
- Is the Facility name in the 1st column of the range you selected?
- Do the facility names match exactly?
If that doesn't help, can you share a screen shot of the 2nd sheet showing the full section that you have referenced and the value you expect to be returned?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!