| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup / #name? error
I get #name? error for this.... =VLOOKUP(A11, sheet2, A1:B26) Please help. Thanks. Mukesh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup / #name? error
the wrokshet function doesn't understand sheet2. by itself
Sheet reference in the worksheet function require a sheet and a range sheet2!A1:B26 Now if you are looking for a string sheet2 then add the double quotes "sheet2" "Mukesh" wrote: I get #name? error for this.... =VLOOKUP(A11, sheet2, A1:B26) Please help. Thanks. Mukesh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup / #name? error
That helped figure out my mistake.
Thank you. Mukesh "joel" wrote: the wrokshet function doesn't understand sheet2. by itself Sheet reference in the worksheet function require a sheet and a range sheet2!A1:B26 Now if you are looking for a string sheet2 then add the double quotes "sheet2" "Mukesh" wrote: I get #name? error for this.... =VLOOKUP(A11, sheet2, A1:B26) Please help. Thanks. Mukesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #N/A Error with VLOOKUP | Excel Worksheet Functions | |||
| vlookup() error #n/a | Excel Worksheet Functions | |||
| Vlookup value not available error | Excel Discussion (Misc queries) | |||
| vlookup error | Excel Discussion (Misc queries) | |||
| Vlookup Error | Excel Worksheet Functions | |||
Linear Mode
