1 match in multiple columns

[orion23]

Good morning All,

I need help with a formula to match a unique value.

Excel book has 2 sheets
Sheet1 and Sheet 2
Sheet1 has the unique value I need to match
Sheet 2 has 3 columns with possible matches (D,E,F)
The resulting value should be a static column in sheet2, let's say column "H"

How can this be done?

Thank you in advance for your support

 

[etaf]

you are welcome