| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match, Find?
Hi,
On column A, there are numbers designated to names on col B. Col A Col B Col C Col D 1 aaa bbb 2 2 bbb ddd 4 3 ccc ddd 4 4 ddd ccc 3 The names on Col C will apprear maybe repeatedly. On col D, I'd like to have a formula that will indicate the designated number of the names as indicated above. Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match, Find?
Hi!
Try this in column D: =INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0)) Copy down as needed. Biff "Danny" wrote in message ... Hi, On column A, there are numbers designated to names on col B. Col A Col B Col C Col D 1 aaa bbb 2 2 bbb ddd 4 3 ccc ddd 4 4 ddd ccc 3 The names on Col C will apprear maybe repeatedly. On col D, I'd like to have a formula that will indicate the designated number of the names as indicated above. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
| Find match between 2 columns and then record data that is in colum | Excel Discussion (Misc queries) | |||
| Find and match totals Genius Req. this should be easier to read | Excel Worksheet Functions | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| Find last match in vllokup | Excel Discussion (Misc queries) | |||
Linear Mode
