Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column
I have 2 different worksheets, I need to compare Column D of worksheet 1 to the range of column A of worksheet 2. If the value in Column D worksheet 1 will match the value in the range of column A worksheet 2 I need to get the value in Column O of worksheet 2.
e.g. Compare value of worksheet 1 column D row 2 to worksheet 2 column A rows 2 - 1000. If worksheet 1 D2 appears anywhere in worksheet 2 A1 to A1000 I want to return the text/value in worksheet 2 column O. If worksheet 1 D2 = worksheet 2 A347 I want to return the text/value in worksheet 2 O347. The repeat this from D2 to D500 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing 2 columns from 2 different Worksheet and Returing Valueof a 3rd column
I have 2 different worksheets, I need to compare Column D of worksheet 1
to the range of column A of worksheet 2. Compare value of worksheet 1 column D row 2 to worksheet 2 column A rows 2 - 1000. If worksheet 1 D2 appears anywhere in worksheet 2 A1 to A1000 I want to return the text/value in worksheet 2 column O. If worksheet 1 D2 = worksheet 2 A347 I want to return the text/value in worksheet 2 O347. The repeat this from D2 to D500 One way is to put this in Sheet1!B2 and copy down as far as needed: =IF(ISERROR(1/(VLOOKUP(D2,Sheet2!A:O,15,FALSE)<"")),"", VLOOKUP(D2,Sheet2!A:O,15,FALSE)) The ISERROR(...) part is meant to return an empty string in two cases: - The value searched for is absent from Sheet2 column A. - It's present, but the corresponding "column O" cell is empty. |
#3
|
|||
|
|||
Quote:
=VLOOKUP('Worksheet1'!D2,'Worksheet2'!$A$1:$B$1000 ,2,FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching Multiples Words in cells and returing it in adjacent cell | New Users to Excel | |||
Comparing two columns some same some add up to others in column 2 | Excel Discussion (Misc queries) | |||
Comparing two columns in two different worksheet. | Excel Programming | |||
comparing 2 columns info to fill 3rd column | Excel Worksheet Functions | |||
Formula that checks several criteria before returing the value??? | Excel Discussion (Misc queries) |