View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pepsinmentos pepsinmentos is offline
external usenet poster
 
Posts: 4
Default lookups with multiple lookup values

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?