Lookup the first non zero value of a row in a range and return it.

[luccallens]

Hi,

Anyone can help me with this one?
I would like to achieve 2 things. Hopefully the attachment is clear.

a) lookup and return the first non zero value of a row in a range, in the example: e.g.: lookup aa in the range and return 5 (the first non zero value)
b) lookup and return the column header (row 1) of the first non zero value in that same range: e.g.: lookup aa in the range and return vv (column header of the first non zero value)

Thanks in advance guys. Much appreciated.

[zbor]

Here, try this:

Edit: Sorry, you wrote first non-zero value. I've return last.
Let me fix it.

[zbor]

Here are both versions.

aa has different input so choose output that give you desired result.

[luccallens]

Thanks a lot man !! Works like a charm.

Much appreciated.

[newdoverman]

Here is one way of doing this.

First non 0:
Array enter (Ctrl + Shift + Enter)

Please Login or Register  to view this content.

Column Header:

Please Login or Register  to view this content.

[luccallens]

And this one is good too !! Thanks for that.