Hi!

Try this:

=MATCH(B1,C$1:C$3000)

Copy down as needed.

Biff

"rich" wrote in message
...
Hi,

Trying to work out how to get the Calc to check if the value of B1 is in
an column C1 to C3000, then return that value in A1.

I have tried to use MATCH but when i put the equation into the rows below,
it incriments the cells so the formula for row 2 would be

=MATCH(B2,C2:C3001)

I need the formula to be

=MATCH(B2,C1:C3000)



Rich