Kelly

The HLookup formula, with the fourth argument False, as you have it,
should work with alphanumeric data. #NA is the response you should
get if there is not an exact match of A11 in the column D of the range
identified by your Indirect(...) function; so, it seems likely that
there is just not a match of A11 .
Good luck.

Ken
Norfolk, Va



On Jun 6, 12:47 pm, vezerid wrote:
On Jun 6, 7:37 pm, Kelly wrote:

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

Kelly,

what values do you have in D2:D104?

Kostis Vezerides