Hlookup?

[eramsva]

Hi experts!

I´m trying to sort some information, seen in the attachet example.

In Cells J3 to L5 I would like to identify the "commodities" used of each offer as per table 1.

I can use Hlookup with many nested IF statements, but is there an easier way?

Thanks for the help!

Martin