| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to bring in the header
I have a worksheet & need to bring into cell M4 the cheapest supplier, 9 of
columns D to L in row 4, we have a formula that brings in the cheapest price into column N from row 19 down. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to bring in the header
I am not sure i understood your question correctly. The below formula finds
the cheapest price in range D19:L19 and then returns the matching header from Row4 range D4:L4. =INDEX(D4:L4,MATCH(MIN(D19:L19),D19:L19,0)) -- Jacob "peterh" wrote: I have a worksheet & need to bring into cell M4 the cheapest supplier, 9 of columns D to L in row 4, we have a formula that brings in the cheapest price into column N from row 19 down. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does one use a formula to bring over the formatting as well | Excel Worksheet Functions | |||
| formula to bring value from another sheet with different spaces | Excel Discussion (Misc queries) | |||
| formula 2 compare text in one cell to another and bring value | Excel Worksheet Functions | |||
| Bring one sheet from one workbook to another via formula | Excel Discussion (Misc queries) | |||
| Formula to bring up to # but not over | Excel Discussion (Misc queries) | |||
Linear Mode
