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)

Leebcor Services

Defined names can't contain space characters.

--
Biff
Microsoft Excel MVP


"bderek95" wrote in message
...
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

"bderek95" wrote:

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)