Am I using the vlookup function correctly?

tellison

I'm using this formula

=VLOOKUP([LifePoint Group Facility]@row, {Facility Stakeholders Report - Anesthesia Range 1}, 14, false)

to lookup a recruiters name in another sheets. I keep getting a #nomatch.

What am i doing wrong?

KPH

Your VLOOKUP looks good. It will return the 1st value in the 14th column from the range selected in your other sheet where the 1st column is an exact match for the data in the "LifePoint Group Facility" column on the current row.

There are a few reasons why a match could not be found.

• Is the Facility name in the 1st column of the range you selected?
• Do the facility names match exactly?

If that doesn't help, can you share a screen shot of the 2nd sheet showing the full section that you have referenced and the value you expect to be returned?

KPH

Your VLOOKUP looks good. It will return the 1st value in the 14th column from the range selected in your other sheet where the 1st column is an exact match for the data in the "LifePoint Group Facility" column on the current row.

There are a few reasons why a match could not be found.

• Is the Facility name in the 1st column of the range you selected?
• Do the facility names match exactly?

If that doesn't help, can you share a screen shot of the 2nd sheet showing the full section that you have referenced and the value you expect to be returned?