Matching Heading with Rank in another Cell

[p17tootie]

I have rank done by rows and I would like to put the name of each company (in column C)that ranked first in another cell. How can I do that?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=XLOOKUP(1,I4:M4,$I$2:$M$2,"")

 

[p17tootie]

that worked!!! Thank you so much. I tried the xlookup but I missed kept putting in something incorrectly and couldn't figure it out. thank you so much!!

 

[p17tootie]

Sorry, I have a follow up, If I added another column in between winning company and Bid for company A and wanted to put the Winning Bid amount which would be the lowest bid ( I would have to disregard the zeros or blank cells). The example up top doesn't have as many blanks or zeros as I have in the complete worksheet. What formula could I use?

 

[Fluff]

You could use the minifs function.