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.

Find more posts tagged with

Accepted answers

All comments

DesireeJones

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.

Colleen Patterson

@mgilkessmith

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.

mgilkessmith

@Colleen Patterson I did this exact test as well as typed the number in because I thought of the extra space issue.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.