Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 3 columns of non-consecutive data in several rows.
Column 1 has description A, description B, description C, description A, description M, etc. Column 2 has description AA, description AD, description AF, description AD, description AO, etc Column 3 has amounts. I need a formula that searches column 1 for all instances of description A. Based on the smallest value associated with the description A items, I want to place the description of column 2 (description result would be in the same row as the smallest value) into the cell the formula is written in. In the cell next to the formula above, I want to place the value (i.e. the smallest value) that corresponds to the first formula's answer/result. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |