Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns na
Hi all!
Sheet1 contains the following: Col_H Col_O 302 33937 158 32840 3582 73345 39760 73455 4412 AGL92 2941 AHW92 136 30044 Sheet2 contains this: Col_H 34132 34332 33532 31032 34433 34633 33937 This is the function I use along Col_I: =IF(ISNA(VLOOKUP(H1;Sheet1!$H$1:$O $7;1;FALSE))=TRUE;VLOOKUP(VALUE(H1);Sheet1!$H$1:$O $7;1;FALSE);VLOOKUP(H1;Sheet!$H$1:$O$7;1;FALSE)) For H7 I would expect the function to return 302, but it only retuns #N/A for all rows in Col_H. I use concatenate to generate the data in Col_O in Sheet1. I also tried to copy the values and do the vlookup inside the same sheet. But still no result. Please, advise! WBR Thommes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup returns #n/a | Excel Worksheet Functions | |||
VLOOKUP Returns a zero value | Excel Discussion (Misc queries) | |||
VLOOKUP returns #N/A | New Users to Excel | |||
VLOOKUP Returns #REF | Excel Worksheet Functions | |||
vlookup returns n/a | Excel Worksheet Functions |