Vlookup with contacts

I'm probably missing something simple here but I can't see it. I'm using Vlookup to get information for contacts from one sheet to an other. Some of the names are getting a #nomatch error, and I have one returning the wrong value. Here are the sheets. I'm removing extra rows to keep it simple. Here is the formula =VLOOKUP(Assignee@row, {Employee Names Range 4}, 2

This is the source sheet. The range is the entire Employee column and the the entire resources type column.

as you can see it's working for me

But not for Greg

Or Tamrat

No formula's used in any of these rows other then the one above. I just can't seem to find what I'm missing. Anyone have any ideas?

Find more posts tagged with

Accepted answers

All comments

Sam_Harwart

Make sure that your column types are identical between the lookup columns and the destination column. Sometimes contact columns are finicky in lookups.

Sameer Karkhanis

Additionally,

Make sure your range (lookup_table) includes all rows
You can force the vlookup to search for exact match by adding FALSE as the last parameter

jevans

Adding FALSE fixed it. I knew it was going to be something simple. Thank you Both for answering.

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.