RE: Lookup

From: Pete (anonymous_at_discussions.microsoft.com)
Date: 09/04/04 

Date: Sat, 4 Sep 2004 09:00:49 -0700

I think the second if statement in my prior reply will do
the trick if you make its precondition if(and
(a1=500000,b1=d1),etc.)

Experiment with it and you should be able to learn what
gives the results you want.

Regards,
Peter

>-----Original Message-----
>Thanks Pete, but I need to clarify this a little. What I
am trying to do is
>for every instance of the 500000 in column A, there will
we a value of either
>0 or the value from E. As you can see the value in
column C does not always
>correspond to A and here in lies my problem. How do I
reference column A,C
>with C changing more frequently than A. Hope this helps
you.
>
>
>"Pete" wrote:
>
>> I see two ways of interpreting your request, so here
are
>> two answers.
>>
>> 1) I would write the following in column F:
>>
>> =if(b1=d1,e1,"")
>>
>> Then copy this down that new column. This puts a
blank
>> in column F if b and d are not equal in that row, and
>> puts the col e value there if they are equal.
>>
>> 2) If you do not want to do this comparison at all
>> unless A and C are equal, then you'll need this:
>>
>> =if(and(a1=c1,b1=d1),e1,"")
>>
>> In other words you do not care to post the e1 value if
B
>> and D are equal, unless A and C are also equal.
>>
>> Your choice--hope this helps!
>>
>> Regards,
>> Peter
>>
>> >What I want to do is reference columns A,C. Then
where
>> columns B and D are
>> >equal show column E. If column A,C are equal but B,D
are
>> not, go to the next
>> >row and do the same comparison
>> >.
>> >
>>
>.
>