Basic Formula Question

  • Thread starter Thread starter Greg B
  • Start date Start date
G

Greg B

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
 
Hi Greg

If I understand your question, you want to make G1 a absolute reference, and
A1 to change as you copy your formula down:

=IF(A1=$G$1,"YES","No")

Hopes this helps.
....
Per
 
Back
Top