i am using a formula on excel that when a month is put into cell C3 it populates data from a different tab into a field.
the formula i am using is
=INDEX('ALERT REGISTER'!B:B,MATCH(C3,'ALERT REGISTER'!A:A,0)+1)
so i add the +1 at the end so that it doesnt generate the same data each time but the one below, so the next formula will have a +2 on the end to generate the next set of data after that and so on...
the problem i am having is when i enter the Date into C3 for example April-17, it will populate all of Aprils information but because i have +1, +2, +3 etc it will also carry on and bring up Mays information when really i want it to stop at April.
can you help with this?
Solved by T. S. in 28 mins