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

"Greg B" <iwccweb(nospam)@ihug.com.au> skrev i meddelelsen
news:71C5DE84-730E-45F1-A3B4-(E-Mail Removed)...
>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

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

"Per Jessen" <(E-Mail Removed)> wrote in message
news:ubDAc6m$(E-Mail Removed)...
> 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" <iwccweb(nospam)@ihug.com.au> skrev i meddelelsen
> news:71C5DE84-730E-45F1-A3B4-(E-Mail Removed)...
>>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
>