HLOOKUP and INDIRECT alpha numeric

K

Kelly

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
 

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

HLOOKUP INDIRECT with alpha numeric worksheets 3
LOOKUP error 4
HLOOKUP second column 7
HLookup indirect multiple worksheets 5
Combine HLOOKUP and MATCH 2
A validation rule on Alpha and Numeric characters 11
Need Help with Alpha into Numeric expressions (not ASCII/ANSI/Etc. 9
Alpha and Numeric in one field 2

Top