I have a sheet with the lowest bidders for three columns. I have written a formula that is searching for the lowest value, and then indexing the header of the column w/ the lowest value, and putting the text in the cell (where the formula is.) The problem is, it's giving me a "000" per my instructions, if the value is not found
I need this formula to grab the column header for the vendor that has provided the lowest bid. There are some conditions that it must work under. These are:
I believe what I have is close. Please let me know if I can help.
<tbody>
</tbody>
I need this formula to grab the column header for the vendor that has provided the lowest bid. There are some conditions that it must work under. These are:
- It must ignore zeros. It must NOT Provide an output for the a vendor that has provided 0 next to two vendors whose values are say 1,2
- If there are multiple text values, AND zero AND a low value, IT MUST PROVIDE THE LOW VALUE (AS IN THIS CASE IT IS THE ONLY VALUE)
- If there is only 1 value, it should provide that value's header, REGAURDLESS of whether there is text or other nonsense in it.
I believe what I have is close. Please let me know if I can help.
PRODUCT | V1 | V2 | V3 | V4 | OUTPUT |
111 | 1 | 2 | 3 | 4 | |
222 | 3 | #N/A | 3 | 4 | |
333 | 2 | #N/A | 2 | 000 | |
444 | #N/A | 2 | 000 | ||
<tbody>
</tbody>
Code:
=IFERROR(INDEX($I$2:$K$2,,MATCH(MIN(I106:K106),I106:K106,0)),"000")