Broken Vlookup (No Match)
My vlookup is returning no match even though there is a match avaliable.
But the reference sheet has an avaliable rate:
Answers
-
Your Vlookup range contains both the SO # and the desired result, with the result being in the 2nd column, is that correct?
Also, are both columns formatted the same way, and include no extra spaces / etc, that would be throwing the returned value off?
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Yes, they have the same info and are formatted the same way - no additional spaces.
-
Hi @TAbs
I notice that in one sheet for your matching values, your numbers appear on the right (indicating they're seen as numerical) whereas in the other sheet the numbers are displaying on the left side of the cell (indicating they're seen as text).
Can you try translating the current sheet's number into a text value, to see if this then finds a match?
=VLOOKUP([SO #]@row + "", {range...etc...
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Great, that worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!