Vlookup formla to return a header help please

Hello

Im after some help please. Ive attached a spreadsheet and what I would like is in cell A2 to look along E2 to K2 and return the first cell which contains a number but instead od showing the number return the date from range E1 to K1 and then the second date in B2 and the third in C2. So the results would be 07/07/2016 for cell A2, 23/10/2016 for cell B2 and finally 28/04/2017 for cell C2.

Thanks for any help.

You can use this array* formula in A2:

=SMALL(IF($E2:$K2>0,$E$1:$K$1),COLUMNS($A:A))

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < Enter >.

Format the cell as a date, then copy across and down as required.

Hope this helps.

Pete

Hello

Both them formulas work great but if there isnt a number its returning #NUM! is there a way for it to return a blank cell if the the number is 0?

Thanks

You can change my formula in A2 to this:

=IFERROR(SMALL(IF($E2:$K2>0,$E$1:$K$1),COLUMNS($A:A)),"")

use CSE to commit the formula, then copy across and down.

Hope this helps.

Pete