Incrementing IF formula's by rows

[Alexvs]

Hi,

I'm trying to copy an IF statement across cells but can't work out how to increment the rows without affecting the columns:

I have a similar table to the one attached and would like to copy the formula in the sales tab across the row for each agent but increment only the row value. We have about 90 agents so I don't want to do it one by one by manually changing the reference. I've only included one row just for an example and included the lookup table in the same workbook which is the 01-12 tab.

Is there any easy way to achieve this?

Thanks

Alex