Match
 

I am trying to use one huge list to look up some values on based on another
smaller, seperate list to see if there are duplicates. I keep trying to use a
match function but I'm not sure if this is the best one to use?

Also every time I try to use a match, if or countif formula and drag it down
the cell references increase with every cell I drag it down to is there a way
to stop this happening?

Match
 

Your match range needs dollar signs

=match(a1,B$10:B$100,0)

"John Cantrell" wrote:

I am trying to use one huge list to look up some values on based on another
smaller, seperate list to see if there are duplicates. I keep trying to use a
match function but I'm not sure if this is the best one to use?

Also every time I try to use a match, if or countif formula and drag it down
the cell references increase with every cell I drag it down to is there a way
to stop this happening?