If "value" then copy from "cellA" to "cellB" drag down issues

Hello all,

My boss has decided a big spreadsheet we use is too big, so I'm trying to create a setup with a master worksheet that contains all data, then worksheets for different categories. After trying some things, I settled on trying to write a statement that searches for a value in the category field, and if it finds it, copies a cell from the master worksheet to the appropriate category specific worksheet. The formula I found to do this is

=IF(ISERR(SEARCH("FALL", 'Master Sheet'!$I$2)), "",'Master Sheet'!$A$2)

My issue is when I try to drag that formula down, I'm hoping for it to change the reference values to I3 and A3, like formulas usually do when you drag them. I have enough data points that changing them manually isn't really an option.

So I'm either looking for a different formula that won't give me the same issues, or a way to get the relative reference to work when I drag.

As an fyi, I'm good enough at Excel to understand the syntax for things like the formula above, but I don't know how to create macros or anything.

thank you!

Now I feel like a total idiot. Ha. Thank you!