Hello everyone,

First time posting here, but I came to you because of a project I'm currently working on.

I have a bunch of fields ranging from name, address, payments, check-out date, etc. on a single "form" that I created on an excel sheet.

In the boxes adjacent to these fields, I've inputted formulas to pull data from a different sheet within the same workbook.
(for example, =IF(List!Y2=0,"No",IF(List!Y2=1,"Yes",IF(List!Y2=2,"Unconfirmed")))

My current problem though is that when I select the entirety of this form, and drag down the bottom right corner, it skips a bunch of rows.
For example, I'd expect the {=IF(List!Y2=0,"No",IF(List!Y2=1,"Yes",IF(List!Y2=2,"Unconfirmed")))} section to become {=IF(List!Y3=0,"No",IF(List!Y3=1,"Yes",IF(List!Y3=2,"Unconfirmed")))}
but instead it jumps to {=IF(List!Y49=0,"No",IF(List!Y49=1,"Yes",IF(List!Y49=2,"Unconfirmed")))}

For the record my "form" is 47 rows long, so I'm guessing it has to be somehow connected.
Is there any way I can drag the same "form" down and continue pulling data row by row?
Thank you very much for all your help!