VLOOKUP error #NAME

  • Thread starter Thread starter bderek95
  • Start date Start date
B

bderek95

I am trying to VLOOKUP text from a column in a different tab in a workbook
but the command continues to return #NAME?. The cells are formated to
"GENERAL", not text. The command is below. Does anyone have advice?
=VLOOKUP('VAMC Restrooms'!Leebcor Services,'VAMC Restrooms'!A:D,2,FALSE)
 
The #NAME error is happening because Leebcor Services is not a valid range
name, but is presented as one in your formula. Is Leebcor Services the actual
value you are trying to look up? If so, your formula could be:
=VLOOKUP("Leebcor Services",'VAMC Restrooms'!A:D,2,FALSE)

Or, if Leebcor Services is a value in a cell (E1, for example) on sheet
'VAMC Restrooms', your formula could be:
=VLOOKUP('VAMC Restrooms'!E1,'VAMC Restrooms'!A:D,2,FALSE)

Hope this helps,

Hutch
 
Back
Top