Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP error #NAME
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP error #NAME
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP error #NAME
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Vlookup is error ( #NA) | Excel Worksheet Functions | |||
VLOOKUP Error | Excel Discussion (Misc queries) | |||
vlookup error | Excel Worksheet Functions | |||
vlookup error | Excel Discussion (Misc queries) | |||
vlookup error | Excel Discussion (Misc queries) |