One way ..

UPC source data assumed in Sheet2 as posted, with indicators being the
number: 1

In Sheet1,
Assume the UPC#'s would be listed in A1 down

Put in B1:
=INDEX(Sheet2!$1:$1,,MATCH(1,OFFSET(Sheet2!$1:$1,M ATCH(A1,Sheet2!A:A,0)-1,),0))
Copy down to return the required results, ie the col headers from Sheet2's
row1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Javier Diaz" wrote:
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.