compare two columns with different ranges in two worksheets
 

I need to compare two columns of data in two different worksheets and display
a third one.

Here it is an example:
-(worksheet1!A1:A10), (worksheet1!B1:B10) and (whorksheet2!C1:C25)
-this is my query, if C5 is already in (A1:A10) I want to display B5 in
worksheet2!D5

I think it is tricky because you need to identity which row in the A1:A10 is
equal to C5 to display B5 and the range are different.

you could save my day
chris90

In worksheet2!D1:
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))

HTH
Kostis Vezerides

brilliant, many thanks, you make my day.

chris90

"vezerid" wrote:

In worksheet2!D1:
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))

HTH
Kostis Vezerides