Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, Could any one tell me how to match the client number from a column to
the d column? And also when the a column matches with d column number, the b and c column nunbers also match with e f automatically. a b c d e f Client number name phone number 106 b 9584 3244 105 a 9825 5471 107 c 9784 2142 106 b 9584 3244 108 d 9880 2262 107 c 9784 2142 109 f 9669 2365 108 d 9880 2262 109 e 9789 1245 110 f 9669 2365 111 g 9550 2231 112 h 9323 5124 113 q 9984 1245 114 w 9956 2314 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match data, count data and report to diffrent sheet. | Excel Discussion (Misc queries) | |||
Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
index,match,match on un-sorted data | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |