Basic Formula Question
 

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

Basic Formula Question
 

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

"Greg B" skrev i meddelelsen
...
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

Basic Formula Question
 

I appreciate the answer. Exactly what I needed. Thank you
Greg B

"Per Jessen" wrote in message
...
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

"Greg B" skrev i meddelelsen
...
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