VLOOKUP error #NAME

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)
 
T

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: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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning #N/A ?? 3
Help matching combined text cells 1
Vlookup 1
Macro 3
VLOOKUP Irk 1
VLookup or Macro? 0
VLOOKUP returning #N/A result 2
help on a vlookup please 5

Top