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. |
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. |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com