| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with Hlookup - need to return values below the matched c | Excel Worksheet Functions | |||
| How to HLookup but return a value in a different column. | Excel Worksheet Functions | |||
| Hlookup, how di I get it to return more than one cell | Excel Worksheet Functions | |||
| Alternative to Vlookup/Hlookup to return a value. | Excel Worksheet Functions | |||
| Hlookup to return a sum of values | Excel Worksheet Functions | |||
Linear Mode
