Formula Fix ,

[LucianBlack75]

Hi

having some trouble with a formula,
=IF(ISNUMBER(MATCH(P105,ARIBA!A2:A1533,0)),1,0)
i have copied the formula copies down the column however it keeps changing the A2 to the next number, how do I keep that constant.

[menem]

A$2:A$1533

Regards.

[LucianBlack75]

OMG thankyou , that fixed that perfectly