VLOOKUP Help

I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if the employee ID is not listed in the completion sheet. I'd also like for it to return a blank value if not listed in the completion sheet.

The formula I'm using is: =VLOOKUP([Employee ID]@row, {Confirmed}, 2, false)

Obviously not right but cannot figure it out. Any help would be greatly appreciated, thank you!

Find more posts tagged with

Formulas

functionality

Cell linking

Accepted answers

Andrée Starå

Hi,

Try this.

=IFERROR(VLOOKUP([Employee ID]@row, {Confirmed}, 2, false),"")

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi,

Try this.

=IFERROR(VLOOKUP([Employee ID]@row, {Confirmed}, 2, false),"")

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

ICue

Andrée,

Worked perfectly, thank you!!! It also helped that I moved my source sheet's columns where they needed to be. Rookie mistake. Thanks again!!!

Stay well,

Irene

Andrée Starå

Excellent!

Happy to help!

Giancarlo

Hello I am having issues as well, I have one sheet (sheet 1) with just company names and who was that company assigned to, then I have another one (sheet 2) that is being populated by a form where who actually contacted that company is recorded. I want to put together a formula that tells me on sheet 1 who actually contacted that company. this is the formula I am using but i get the same name across the whole thing. any help is appreciated.

=VLOOKUP("Business@row", {Covid 19 Member Contact Range 1}, 3)

Andrée Starå

Hi @Giancarlo

Try something like this.

=VLOOKUP(Business@row, {Covid 19 Member Contact Range 1}, 3)

Example: =VLOOKUP([Destination Sheet Column]@row; {Source Sheet Range}; 5; 0)

=VLOOKUP([Column with the value to match against]@row; {Source sheet range where the first column in the range has to contain the value we want to match}; 2 <This number we use to select the column from where we want to get the value, and from the starting column; 0<Indicates that we want to find an exact match)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.