| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching Multiple columns in Excel.
What i am trying to do is
if i have 5 columns A B C D E 25 2 3 a P 22 5 4 b 24 3 10 g A 55 8 15 k 61 9 2 p 7 0 21 d column A and B have related info. C and D HAS related info . I want to see if any entry in column C matches any entry in B, Then the corresponding row VALUE from D should be copied to a new column E in the same Row as B Eg here C1 matches B3 ( value 3) then value D1 which is value a should be copied to E3 which is same row as B3 C5 matches B1 so the value p should be copied to E 1. Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching Multiple columns in Excel. | Excel Discussion (Misc queries) | |||
| Matching Multiple Columns | Excel Worksheet Functions | |||
| Matching multiple columns and retrieving a value | Excel Worksheet Functions | |||
| Matching multiple columns | Excel Worksheet Functions | |||
| Matching data in multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
