Hi there,
I have an array formula in A1:
{=IFERROR(INDEX(leave_dates[Status],MATCH(1,([@NAME]=leave_dates[Name])*(VALUE(anuual_leave[[#Headers],[69]])>=leave_dates[Start Date Mod])*(VALUE(anuual_leave[[#Headers],[69]])<=leave_dates[Finish Date Mod]),0),),"")}
And what I need to do is put this formula into the consequent columns B,C,D,E etc. but as each column moves across I need the "69" number in the formula to increase by one. So the formula in B1 would be as above but with the number 70 instead of 69 and so on.
I really appreciate your help because I need to copy this formula over to many many columns!
Bookmarks