using VLOOKUP with two table_array

  • Thread starter Thread starter loparque
  • Start date Start date
L

loparque

Hi, I have the next problem:
I'm trying use VLOOKUP and I have to find the data in two table_array
that are in different sheets.

I proved joining with OR function in order to obtain lookup_value i
exist in one of the table_arrays but the results is wrong.

I did:


=OR(VLOOKUP(vlookup_value;table_array1,2,false);VLOOKUP(vlookup_value;table_array2,2,false))

expecting to get a good result, but if one of the vlookup gets #N/A an
the other gets the vlookup_value, the total result of the formula i
#N/A

Maybe I wasnt clear,sorry for my english, but I hope somebody can hel
me. I can send a little spreadsheet if somebody could help me fo
understand me more easy

thankss !!!


loparqu
 
Z2:

=VLOOKUP(LookupValue,LookupTable1,2,0)

Y2:

=IF(ISNA(Z2),VLOOKUP(LookupValue,LookupTable2,2,0),Z2)

X2:

=IF(ISNA(X2),"",Y2)

X2 is the result cell.
 
Typo...

X2 should house:

=IF(ISNA(Y2),"",Y2)

Aladin Akyurek said:
Z2:

=VLOOKUP(LookupValue,LookupTable1,2,0)

Y2:

=IF(ISNA(Z2),VLOOKUP(LookupValue,LookupTable2,2,0),Z2)

X2:

=IF(ISNA(X2),"",Y2)

X2 is the result cell.

loparque > said:
Hi, I have the next problem:
I'm trying use VLOOKUP and I have to find the data in two table_arrays
that are in different sheets.

I proved joining with OR function in order to obtain lookup_value if
exist in one of the table_arrays but the results is wrong.

I did:
Click to expand...
=OR(VLOOKUP(vlookup_value;table_array1,2,false);VLOOKUP(vlookup_value;table_
Click to expand...
 
Back
Top