I am not sure how to do this, but I have created the following formula
=IF(A1=G1,"YES","No")
then I would
=IF(A2=G2,"YES","No")
What this does is a search of the index.

The problem is if I have a lot of numbers I have been copying the item and
pasting the whole column. I assume there is an easier way so I can just
have the item added at range g1 and all formulas just use the same cell?

Sorry but it is really annoying me.
Thanks in Advance
Greg B