VLOOKUP Help

ICue

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!

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!

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!

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!