Confirming Vlues in 2 Cells Appear in a List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)),"Y","N")

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

Hope this helps!
 
Just what I was looking for! Thanks!

Domenic said:
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!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I look up a value in a table with 2 criteria? 1
Adding up data in multiple cells for a single criteria. 1
Heavy data munching - is there a more efficient way of doing this? 8
How to retrieve last date and amount from columns? 5
Find match between cells and copy data 7
SUMIF Formula not working 1
match values in two column and return value in 3
Increase value of number in formula/using named cells. And use ofIF sentence 10

Back
Top