ExcelBanter - HLOOKUP return NA#

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HLOOKUP return NA# (https://www.excelbanter.com/excel-discussion-misc-queries/245482-hlookup-return-na.html)

jase

HLOOKUP return NA#

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

smartin

HLOOKUP return NA#

Jase wrote:
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

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

Stefi

HLOOKUP return NA#

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

Regards,
Stefi

€žJase€ ezt Ã*rta:

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

All times are GMT +1. The time now is 01:34 AM.