Good Morning everyone,

This one has stumped me. Of course, it may look like a piece of cake for
many of you, but when I have hundreds of formulas running around in one
workbook, my brain is starting to get fried. I even forgot to do a vlookup
for a few seconds this morning, lol.

Ok, so this is what I want to do.

I want a formula to look at an UPC in a range, then Look to see when that
upc is to launch in a range of cells, then return the column header of where
the indicator resides that it will launch. I'll show below;

UPC is in Sheet 1 in CEll A1

UPC data is in Sheet 2 in Column A

Colunms B1:E1 have dates like so;

9/15 6/8 9/18 etc.

Range B2:E500 has indicates like a 1 which will then indicate that if UPC
123 launches on 9/18, which would be cell D23, then return 9/18 which is the
header of that cell.

I hope I explained it right.