compare two columns with different ranges in two worksheets

[ch90]

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

[vezerid]

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

[ch90]

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
>
>