How to VLookup Instructor Client from a sheet


I am trying to do a Vlookup from our DPS Master Directory sheet?

We have the last name and first name in both sheet. I want to pull the Client name for each instructor from the DPS Master Directory sheet.

The formula I used:

=INDEX({DPS Master Directory}, MATCH(Client@row, {DPS Master Directory}, 0))

Below is the sheet where I want the formula to be.

The sheet below is where I want to pull the data from:



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!