Naamloos.png
See above image.
I am looking for a formula that returns the header for the second and third value possible in the row.
currently i have a working formula for the first value which returns the first header:
=INDEX($B$2:$I$2;MATCH(TRUE;INDEX(B1:I1<>0;0))
and also for the last value which returns the last header:
=IFERROR(LOOKUP(2;1/(B2:I2<>"");$B$1:$I$1);"None found")
Bookmarks