You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lmm" wrote in message
...
You are awesome!!! Truly MVP. Thanks! This is what I want.

"T. Valko" wrote:

Let's see if this is what you want:

...........A..........B..........C..........D
1....................X..........Y..........Z
2....SKU1......0...........0..........5
3....SKU2......1...........2..........4
4....SKU3......0...........3..........1
5....SKU4......0...........0..........2

Return the column header for the 1st non-zero value (assuming there are
no -ve values) that corresponds to SKUx

A10 = SKU3

This array formula** :

=INDEX(B1:D1,,MATCH(TRUE,INDEX(B2:D5,MATCH(A10,A2: A5,0),0)0,0))

Returns Y

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


I didn't express my question clearer. Take this example that each
inventory
row represents one SKU commit wk units. By giving one SKU and find out
the
first nonzero cell for that SKU row is what I am looking for. I am not
doing
serial request for all rows together. In summary, if I find the row #
for
one specific SKU in qeustion, how to incorporate the row # into the
formula?
Thanks.

Lmm


Hi Lmm,

[snipped]
=INDEX($D$1:$IV$1,,MATCH(TRUE,D3:IV30,0))

In this case row 3 was just an example. Start with the formula in row
3
and fill down, it will adjust.


"Lmm" wrote in message
...


"smartin" wrote:

Lmm wrote:
Hi,

I tried the INDEX & MATCH formulas and it works! But if my row # is
dynamic, i.e. take your example below that if row 3 be replaced with
different row #, how to incorporate the dynamic # in MATCH.