Thread
:
Confirming Vlues in 2 Cells Appear in a List
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Jamie M
Posts: n/a
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.
Reply With Quote