using VLOOKUP with two table_array

[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

 

[Aladin Akyurek]

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.

 

[Aladin Akyurek]

Typo...

X2 should house:

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

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.

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:

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

 

[loparque]

thanks a lot Aladi