View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TomO TomO is offline
external usenet poster
 
Posts: 3
Default lookup table multivalue

Can lookup look at two values (in separate columns) and return the value in
the third column. e.g. I want a spreadsheet where i can input the product
type in column 1 (e.g. coke) and the size in column 2 (e.g. 1.5L) and
automatically fill the third column with the price. I'm using Excel 2003