| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Index/Match Functions to Return Concatenated Response
So, this should be pretty easy for someone to solve.
Basically, I have a data set that shows usage, by part (row), by city (column). Example: ATL, CHI, DAL, HOU Part A 1 2 3 4 Part B 5 7 3 6 I have another sheet that shows just the part and I want to have the formula pull the city and qty based on the highest value in the part row. So, for example: Part A Cell Formula (find Part A from above sheet, find highest value in Part A row, reference the city from that row/column, and display "City - Qty". So, for Part A, the formula value would be "HOU - 4" and for Part B it would be "CHI - 7". Anyone know how to do this? I have a huge list of parts and about 30 cities and need to find the highest value/city in each part. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX and MATCH functions | Excel Worksheet Functions | |||
| Row, Index, Match functions | Excel Discussion (Misc queries) | |||
| #n/a response while using the match/index? | Excel Discussion (Misc queries) | |||
| Index and Match Functions | Excel Worksheet Functions | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
Threaded Mode
