I have a formula that finds the lowest bid from a bunch of suppliers, which is just a min function. But now I want it to display the companies name..
I have highlighted the cells yellow that I am trying to populate with the company names.
Any ideas? I attached the file to this post.
EDIT: Figured it out by using =IF(A3="","",INDEX($L$2:$CA$2,MATCH(G3,L3:N3,0)))
Bookmarks