Original Formula:
=IF((AND(Registration!M2>=0,Registration!M2<=1)), importrange("0AiZ17ZdTbOhMdENjWU9aTXNfN1pVUlJ6Mzk0V21hMHc", "Registration!A2:J2"), (T1*0))
Formula after dragging it down:
=IF((AND(Registration!M3>=0,Registration!M3<=1)), importrange("0AiZ17ZdTbOhMdENjWU9aTXNfN1pVUlJ6Mzk0V21hMHc", "Registration!A2:J2"), (T2*0))
Notice: the first part of the formula is changing, but the last part ("Registration!A2:J2") is not
Is there a way to get this to auto adjust as we drag the formula down without having to manually go through each one?
Bookmarks