How do I freeze a data range when I drag it to a new cell?

[James]

I'm trying to use the formula here: =ISNA(MATCH(J2,B2:B347, FALSE))

To analyze list when I drag this formula into a new cell it automatically
adjusts the range B2:B347 to B2:B348, and so on.

The trick is that I want it to automatically adjust the search value, J2 to
J3 ....

What do I need to freeze this range.

Thanks

 

[Sandy]

Try =ISNA(MATCH(J8,$B$2:$B$347, FALSE))

Sandy