Find value based on two lookup values
 

Hi,

This is my spreadsheet:

A B C
1 ID Type Number
___________________________
2 10 Green 12
3 10 Red 11
4 10 Blue 10
5 10 White 19
6 20 Green 33
7 20 Red 27
8 20 Blue 15
9 20 White 10


How do I find the value in column C for: ID 10 in combination with Type
white?

Have tried with Index and Match but have not succeeded.
=INDEX(A2:C9,MATCH("10"&"White",A2:A9 & B2:B9,0),3)
Using Excel 2007
Hope someone can help.

Best regards,
Kaj Pedersen

---
Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.
http://www.avast.com

Find value based on two lookup values
 

On Sunday, October 27, 2013 9:20:46 AM UTC-7, wrote:
Hi,



This is my spreadsheet:



A B C

1 ID Type Number

___________________________

2 10 Green 12

3 10 Red 11

4 10 Blue 10

5 10 White 19

6 20 Green 33

7 20 Red 27

8 20 Blue 15

9 20 White 10





How do I find the value in column C for: ID 10 in combination with Type

white?



Have tried with Index and Match but have not succeeded.

=INDEX(A2:C9,MATCH("10"&"White",A2:A9 & B2:B9,0),3)

Using Excel 2007

Hope someone can help.



Best regards,

Kaj Pedersen



---

Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.

http://www.avast.com

Try

=SUMPRODUCT((A2:A10=D1)*(B2:B10=E1)*(C2:C10))

Where D1 is an ID and E1 is a Type.

Regards,
Howard

Find value based on two lookup values
 

Hi Howard,

Thank you very much for your suggestion.
It works to my fully satisfaction.

Regards,
Kaj Pedersen

---
Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.
http://www.avast.com