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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!