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