Dropping cell numbers in a formula as you auto-fill across columns

Hi, is there a way to drop cell numbers in a formula as you drag the formula across a number of columns?

For example, if in B6 I have "=IF(AND(B$5=OrderedBlindingCodeMatches!$A$2,$A6=OrderedBlindingCodeMatches!$B$2),1,0)", then in C6 can I have "=IF(AND(B$5=OrderedBlindingCodeMatches!$A$3,$A6=OrderedBlindingCodeMatches!$B$3),1,0)", and so on, without changing the numbers by hand?

Example attached...

Test.xlsx

Thank you

Here!

Try This in B6 -

Drag Across and Down -

=IF(AND(B$5=INDIRECT("OrderedBlindingCodeMatches!A"&COLUMN(B1)),$A6=INDIRECT("OrderedBlindingCodeMatches!B"&COLUMN(B1))),1,0)

But I have doubts with your above formula, the way you have made the references absolute.. Hope this is how you required it initially.

Deep

Glad it helps!

Deep