Hi pepsinmentos,

You may also want to take a look here,
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH
Martin



"pepsinmentos" wrote in message
...
If I have a list of products that each come in a different colour and have
a
different price, how can I look up the price using both values 'Product'
and
'Colour'?

ex.

A B C
1 Car Red 1000
2 Car Blue 2000
3 Bike Orange 500
4 Bike Red 700
5 Bike Blue 1000

Now, if I have a cell with Car and a cell with Red.... How do I get the
corrosponding price?