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?