If formula the returns text

[Lino 2970]

Hi everyone,
I have a table with Suppliers pricing in columns F through M. I would like a If formula that states that if the price in Column N equals the price in Columns F-M then return the name of that supplier.Capture.JPG

[Sam Capricci]

try index match for that...
=INDEX($F$1:$L$1,MATCH(N2,F2:L2,0))

[KOKOSEK]

Deleted. Already sorted.

[Lino 2970]

Thank you very much

[Sam Capricci]

You're welcome, AND thank you for the rep!