# 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!

• ✭✭✭

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

• ✭✭✭✭✭✭

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• 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)

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!