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.
Bookmarks