Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compare the lists in two columns & separate odd one ? | Excel Discussion (Misc queries) | |||
Compare columns | Excel Discussion (Misc queries) | |||
How do I compare 2 columns in excel from the same spreadsheet | Excel Discussion (Misc queries) | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
Problem with graph ranges | Charts and Charting in Excel |