Vlookup resulting in blank value

Hello, I am using VLOOKUP formula and need some assistance please.

I am searching "Primary Column" in one sheet and looking up that name on another sheet (within 2 columns CompanyName & AssociationName). This is the formula I am using

=VLOOKUP([Primary Column]@row, {Collectronics Export Source Sheet Range 1}, 1)

FYI, the #2 showing in PMC column I tried using MATCH formula not VLOOKUP. As you can see in PMC it is blank, any suggestions?

Thank you,

Brad

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

The VLOOKUP requires that the lookup table's first column contain the search value. Does your reference range have the Association Range or the Company Name as the first column? If it is the Association Range, that would explain why it isn't returning anything, because it is finding no matches.

Mike Wilday

Yes, I agree with @David Tutwiler check your sheet reference range. You need to start the range with the company name as the first column and then reference the column number of the column that contains the data based on your adjusted range.

Brad Mulder

Thanks guys, I changed the order of the columns, added "false" at the end of the formula and it worked. Thanks again!

Mike Wilday

Awesome. Glad to confirm.

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.