I have below formula in excel:
=IF(ISRRFEEDLY(INDIRECT(ADDRESS(MATCH("Kelly",Grafik!H1:H70,0),COLUMN(Grafik!H1:H71),4,,"Grafik"))), "RR Feedly", FALSE)
Whenever I drag this formula down, the reference to range changes from H1 to H2 etc. What I want to achieve is to whenever I drag it down, it changes from H1 to I1, J1 etc.
I was messing around with OFFSET function but couldnt make it work.