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