VLOOKUP Cross Reference other sheet issue
I am having an issue where my VLOOKUP formula is working for some numbers but not others. I have two inventory sheets - one inventory of Product A with serial numbers that were delivered to satellite locations and then another sheet of the satellite location inventory. Not all Product A at the satellite were sent by us, some were by other vendors. I want to find out with a cross reference which of Product A were provided by us.
This is my current formula:
=VLOOKUP(SerialNumber@row, {Satellite Delivered Product A Inventory Range 1}, 1)
If there is no match, I get a #NO MATCH, which is fine. But not all of the Serial Numbers are being found. Many are finding a match, but not others. I have looked at the format, etc. Cannot figure it out.
Answers
-
Hello @mgilkessmith ,
I have the same issue, but with a VLOOKUP within the same sheet. Earlier this week I believe that there were similar issues where some functionalities were not available due to a server being down.
-
As a test, you should find one of the values that do not appear to be returning. Then copy the SerialNumber from the source sheet and copy it into the sheet you are looking up. If that resolves your issue there may be something like an extra space being added that is causing the discrepancy.
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.
-
@Colleen Patterson I did this exact test as well as typed the number in because I thought of the extra space issue.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!