HLOOKUP return NA#

J

Jase

I am trying to do an HLOOKUP from one excel workbook to another but it is
returning NA#. I know this can be done but not sure why its not working now.

thanks,

Jase
 
S

smartin

Jase said:
I am trying to do an HLOOKUP from one excel workbook to another but it is
returning NA#. I know this can be done but not sure why its not working now.

thanks,

Jase
Click to expand...

Check the common reasons for failed lookups: data types (especially
numbers stored as strings), extra/trailing spaces, non-printing characters.
 
S

Stefi

You should provide more details, sample data, layout, formula giving #NA, etc.

Regards,
Stefi

„Jase†ezt írta:
 
Top