On a monthly basis a sheet of data is inserted into a different worksheet, each worksheet named after the month.
What I want to do is check to see if the data is in these 12 pre-named worksheets and place a value in the cell, like the following:
=IF(AugPerf!A2>0,8,IF(JulPerf!A2>0,7,IF(JunPerf!A2>0,6,IF(MayPerf!A2>0,5,IF(AprPerf!A2>0,4,IF(MarPerf!A2>0,3,IF(FebPerf!A2>0,2,IF(JanPerf!A2>0,1,0))))))))
However, as you will be aware you cannot nest the if for more than 8 I think, can you help as to how i progress this one.
What I want to do is check to see if the data is in these 12 pre-named worksheets and place a value in the cell, like the following:
=IF(AugPerf!A2>0,8,IF(JulPerf!A2>0,7,IF(JunPerf!A2>0,6,IF(MayPerf!A2>0,5,IF(AprPerf!A2>0,4,IF(MarPerf!A2>0,3,IF(FebPerf!A2>0,2,IF(JanPerf!A2>0,1,0))))))))
However, as you will be aware you cannot nest the if for more than 8 I think, can you help as to how i progress this one.