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

I'm trying to use the formula he =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

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

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

Sandy

"James" wrote in message
...
I'm trying to use the formula he =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