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