Hello,
In column P I have a formula that finds the lowest price in columns G,K and M. This formula neglects values if they are 0.
In column O i am trying to say who has the lowest price which is the headers of columns G K and M.(Tom, Frank and Tate)
My current formula in O309 is: =IFS(MATCH(P309,G309:M309,0)=1, "Tom", MATCH(P309,G309:M309,0)=5, "Frank", MATCH(P309,G309:M309,0)=7, "Tate")
the issue is that the array is finding a $0.03 in column I and reporting the match number as 3.
Is there a way I can tell excel to not accept this value and keep going?
Is there a better method to do this? I cannot rearrange the column orders either.
Thank you,
tate.PNG
Bookmarks