Autofill problem with Dragging the formula down

**mollyray2** · 09-23-2011, 01:29 PM

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?

**tlafferty** · 09-23-2011, 01:33 PM

You must remove the quotation marks or Excel will treat the reference as text instead of a reference.

**GuyMor** · 06-14-2017, 07:07 AM

But the formula needs the " " around the sheet name... how do you solve that?

**xlnitwit** · 06-14-2017, 07:14 AM

Hi,

Perhaps like this
=IF((AND(Registration!M2>=0,Registration!M2<=1)), importrange("0AiZ17ZdTbOhMdENjWU9aTXNfN1pVUlJ6Mzk0V21hMHc", "Registration!A"&ROW(A2)&":J"&ROW(A2)), (T1*0))