Confirming Vlues in 2 Cells Appear in a List
 

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.

Confirming Vlues in 2 Cells Appear in a List
 

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

=IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),"Y","N")

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

Hope this helps!

In article ,
Jamie M <Jamie wrote:

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.

Confirming Vlues in 2 Cells Appear in a List
 

Just what I was looking for! Thanks!

"Domenic" wrote:

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

=IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),"Y","N")

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

Hope this helps!

In article ,
Jamie M <Jamie wrote:

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.