I need the Header of Multiple values to pull up excluding 0

[Bryan Mong]

I have a spreadsheet I am working on and I need to be able to pull up the best priced vendor in Column L. The formula I used works great but I need it to exclude 0.
Here is the formula : =INDEX($C$1:$G$1,MATCH(MIN($C4:$G4),$C4:$G4,0))
I have also attached the spreadsheet.

Thanks,

Bryan

 

[Nebu]

Hi:


Use the following array

=INDEX($C$1:$H$1,MATCH(MIN(IF(CHOOSE(ROW($1:$3),C3,E3,G3)>0,CHOOSE(ROW($1:$3),C3,E3,G3))),$C3:$H3,0))

formula

Execute pressing control+shift+enter keys

I have indexed the vendor name based on Cost only.


Thanks

 

[Bryan Mong]

Hi:


Use the following array

=INDEX($C$1:$H$1,MATCH(MIN(IF(CHOOSE(ROW($1:$3),C3,E3,G3)>0,CHOOSE(ROW($1:$3),C3,E3,G3))),$C3:$H3,0))

formula

Execute pressing control+shift+enter keys

I have indexed the vendor name based on Cost only.


Thanks

Thank you it works perfectly.