VLOOKUP - NO MATCH
Could you hrelp me to short out this problem?
I want to copy the "NAC ID" in a cell using Vlookup formula. But I always get "NO MATCH".
Data collected from a form:
Used Formula:
"Affected units" is a dropdown column with multiple selection.
Best Answer
-
Hi,
For VLOOKUP to work, the value that you are looking up should be in the left and anywhere in the right of that could be the column from where you intend to fetch values. If you are using the look up value as ID#0133 NOK, the value to fetch should be in a column that is to the right side of this value's column. Also note that if there are multiple of the same values in the reference sheet, with various NAC ID, the system will not be able to fetch the result. It has to be one to one.
Below is where you will get a no match
However, if you change as shown below, you will get a value, provided it is one to one
Hope this helps.
Thanks,
Aravind
Thanks,
Aravind
Associate Director
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: aravind@copernicusworld.com
Feel free to reach out for licenses, services, and training on Smartsheet
Answers
-
Hi,
For VLOOKUP to work, the value that you are looking up should be in the left and anywhere in the right of that could be the column from where you intend to fetch values. If you are using the look up value as ID#0133 NOK, the value to fetch should be in a column that is to the right side of this value's column. Also note that if there are multiple of the same values in the reference sheet, with various NAC ID, the system will not be able to fetch the result. It has to be one to one.
Below is where you will get a no match
However, if you change as shown below, you will get a value, provided it is one to one
Hope this helps.
Thanks,
Aravind
Thanks,
Aravind
Associate Director
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: aravind@copernicusworld.com
Feel free to reach out for licenses, services, and training on Smartsheet
-
Thanks a lot Aravind,
It works for the first cell that match the criterio, how could I get all the values that matches the criterio in the selected range?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!