I'm trying to get some row numbers so I may run a countif function. However, I am getting a #N/A error.
My formula is:
=(MATCH(INDEX(N3,1,1),'Sheet2'!A2:A10000, 0))+1
cell N3 is a reference to another cell (=A6; A6 = =DATE(YEAR(C2),MONTH(C2),DAY(1)))
'Sheet2'!A2:A10000 is a whole bunch of dates, once again referenced from another sheet (e.g. 'Sheet2'!A2 = 'Raw data'!A2)
I figure my referencing in my MATCH formula.
Any ideas ? ?
Thanks
My formula is:
=(MATCH(INDEX(N3,1,1),'Sheet2'!A2:A10000, 0))+1
cell N3 is a reference to another cell (=A6; A6 = =DATE(YEAR(C2),MONTH(C2),DAY(1)))
'Sheet2'!A2:A10000 is a whole bunch of dates, once again referenced from another sheet (e.g. 'Sheet2'!A2 = 'Raw data'!A2)
I figure my referencing in my MATCH formula.
Any ideas ? ?
Thanks