VLOOKUP error #NAME

[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,2,FALSE)

 

[T. Valko]

Leebcor Services

Defined names can't contain space characters.

 

[Tom Hutchins]

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,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,2,FALSE)

Hope this helps,

Hutch