| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP and INDIRECT alpha numeric
Thanks to the help from a prior posting, I have the following calculation in
my spreadsheet: =HLOOKUP(A5,INDIRECT("'"&$A5&"'!D2:H104"),3,FALSE) This macro searches through several worksheets with lease numbers (e.g. 003403, 021456) to produce the results. When I have a lease number that includes a letter (e.g. 003403R, 045789A), I receive an #N/A response. Can you please tell me where I've gone wrong and/or what I need to change in my formula? Thanks Kelly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP INDIRECT with alpha numeric worksheets | Excel Worksheet Functions | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| +1, Alpha *and* Numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
