Ok Max, that forumla is just sick. Watch out David Blane, Max is coming.
Wow, how in the heck did you do that. Man, I thought I had some slight idea
on how to create advance formulas, but your a Genius, how how how how how. I
must study this one big time.

"Max" wrote:

Here's a revised formula which will cater for a single indicator (it can be
any type of input) per UPC# line in source range. The rest of the line range
must be left blank.

An illustrative sample, tailored to fit your set up is available at:
http://www.flypicture.com/download/MTIzNTA=
Match within range n return col header.xls

Array-entered* in B1:
=INDEX(Sheet2!$O$22:$U$22,,MATCH(TRUE,OFFSET(Sheet 2!$O$22:$U$22,MATCH(A1,Sheet2!$G$22:$G$6500,0)-1,)<"",0))
*press CTRL+SHIFT+ENTER to confirm the formula

Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Javier Diaz" wrote:
Something is weird, I changed the formula around and it doesnt seem to work

=INDEX('[Test'!$O$22:$U$22,,MATCH(1,OFFSET('[tEST'!$O$22:$U$22,MATCH(G20,'[tEST'!$G$23:$G$6500,0)-1,),0))

i NEED IT TO LOOK IN RANGE o23-U6500 FOR A QTY GREATER THAN 1, i DIDN mean
to specify it to 1 only.

Then if it finds something in whatever column between o and u in that range,
to return the corresponding column header, wghich is O22:U22. You were in
the right track, but maybe I'm lost.