software

I have a quick and hopefully simple questions.

I have a source list of data (for example):

BLR1 SL1 10000
BLR2 SL2 20000
BLR3 SL3 30000
BLR4 SL1 30000

In another list, I have two input conditions in two different cells:
SL1 20000 x

I'd like a third cell where the 'x' is to tell me if I have already have
that combination in the source list. If so, indicate with a 'y'; if not;
indicate with an 'n'.

The input above would indicate an 'n', an entry of SL3, 30000 would indicate
a 'y'. The source data field may be random and not sorted in any particular
order.

Thanks.Assuming that A2:C5 contains your data, try...

=IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),quot;Yquot;,quot;Nquot;)

....where E2 contains the first criteria, such as SL3, and F2 contains
the second criteria, such as 30000.

Hope this helps!

In article gt;,
Jamie M lt;Jamie gt; wrote:

gt; I have a quick and hopefully simple questions.
gt;
gt; I have a source list of data (for example):
gt;
gt; BLR1 SL1 10000
gt; BLR2 SL2 20000
gt; BLR3 SL3 30000
gt; BLR4 SL1 30000
gt;
gt; In another list, I have two input conditions in two different cells:
gt; SL1 20000 x
gt;
gt; I'd like a third cell where the 'x' is to tell me if I have already have
gt; that combination in the source list. If so, indicate with a 'y'; if not;
gt; indicate with an 'n'.
gt;
gt; The input above would indicate an 'n', an entry of SL3, 30000 would indicate
gt; a 'y'. The source data field may be random and not sorted in any particular
gt; order.
gt;
gt; Thanks.

Just what I was looking for! Thanks!

quot;Domenicquot; wrote:

gt; Assuming that A2:C5 contains your data, try...
gt;
gt; =IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),quot;Yquot;,quot;Nquot;)
gt;
gt; ....where E2 contains the first criteria, such as SL3, and F2 contains
gt; the second criteria, such as 30000.
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Jamie M lt;Jamie gt; wrote:
gt;
gt; gt; I have a quick and hopefully simple questions.
gt; gt;
gt; gt; I have a source list of data (for example):
gt; gt;
gt; gt; BLR1 SL1 10000
gt; gt; BLR2 SL2 20000
gt; gt; BLR3 SL3 30000
gt; gt; BLR4 SL1 30000
gt; gt;
gt; gt; In another list, I have two input conditions in two different cells:
gt; gt; SL1 20000 x
gt; gt;
gt; gt; I'd like a third cell where the 'x' is to tell me if I have already have
gt; gt; that combination in the source list. If so, indicate with a 'y'; if not;
gt; gt; indicate with an 'n'.
gt; gt;
gt; gt; The input above would indicate an 'n', an entry of SL3, 30000 would indicate
gt; gt; a 'y'. The source data field may be random and not sorted in any particular
gt; gt; order.
gt; gt;
gt; gt; Thanks.
gt;