Formula using pattern

Hey guys!

I need a formula that skips a given number of columns when referencing the cells I need. Let's consider the following formula:

Formula:

=IF(B2=Anotados!C3;Anotados!D15;0)

This is the base formula I need. The next cell must be:

Formula:

=IF(C2=Anotados!G3;Anotados!H15;0)

and the next one:

Formula:

=IF(D2=Anotados!K3;Anotados!L15;0)

and so on...

But, obviously, if I click and drag the formula doesn't follow this pattern, and I need it to be applied to multiple cells in a row, otherwise I could do it manually instead. That's when I came across the INDIRECT function that I saw here: excel.tips.net/T003067_Copying_Formulas_using_a_Pattern.html
I understand that I should use the function COLUMN instead of ROW that he used in the example, but I have no idea how to write the formula combining the INDIRECT function with IF without getting an error

Does anyone have a clue about that?