Formula Help - pulling text from cell A to B if cell C contains specific text

[ia1n]

Hi all, hope all is bright and sunny out there,

Image is an example.

My top row lists product codes.
Each of the following rows contain cells underneath these names which indicates if that product is being used and a date.
I've been able to pull the date from the cell in each row into a separate column (there's probably a way to combine this).
I'd like column 'I' to show the product code from the top row if there is an entry in that column. So 'I2' would show 'D', 'I3' would show 'C', etc etc...

I hope that makes sense! Thanks in advance.

Iain

 

[Joe4]

Welcome to the Board!

Put this formula in cell I2 and copy down for all rows:

=INDEX($B$1:$F$1,MATCH(G2,B2:F2,0))

 

[ia1n]

Welcome to the Board!

Put this formula in cell I2 and copy down for all rows:

=INDEX($B$1:$F$1,MATCH(G2,B2:F2,0))

Thank you! This is a very useful function.

May your next fortune cookie explode with confetti and dollar bills.

Iain

 

[Joe4]

Thank you! This is a very useful function.

You are welcome! Glad I was able to help!

May your next fortune cookie explode with confetti and dollar bills.

Sounds good to me!