| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP error
When I use the following formula:
=HLOOKUP(A11,INDIRECT("'"&$A11&"'!D2:H104"),3,FALS E) with a lease number 003403 - everything is fine and the correct data is returned. When I use the formula with lease number 003403A, I received #NA in every cell. Is there a way to HLOOKUP an alpha numeric field with the formula I'm using? Thanks, Kelly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and #N/A Error | Excel Worksheet Functions | |||
| LOOKUP and #N/A Error | Excel Worksheet Functions | |||
| Lookup error | Excel Discussion (Misc queries) | |||
| lookup error! | Excel Worksheet Functions | |||
| sum / lookup w error correction | Excel Worksheet Functions | |||
Threaded Mode
