| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with multiple condition, but one condition to satisfy is en
Hi
I am looking to compare 2 sheets with 20 columns but i need to compare sheet 1 having 75 rows & sheet 2 having 2000 rows sheet1 column d d2:d75 to compare in sheet2 column b b2:b2000 sheet1 column e e2:e75 to compare in sheet2 column b c2:c2000 sheet1 column f f2:f75 to compare in sheet2 column k k2:k2000 even if one cell in sheet1 (d,e,f) column is matching with sheet2 b,c,k it is enough. row 1 is title in both the sheets, title is common. i need that data to be displayed in the formula cell. formula to be place in sheet1 b2 column and copy formula down to b75 advance thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set row height to zero if the condition satisfy | Excel Discussion (Misc queries) | |||
| Multiple Lookup as condition in sumproduct formula | Excel Worksheet Functions | |||
| Checking a second lookup condition | Excel Worksheet Functions | |||
| multiple condition lookup and match cell format | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
