lookup table multivalue

  • Thread starter Thread starter Tomo
  • Start date Start date
T

Tomo

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
 
One way...

A1:A10 = product name
B1:B10 = product sizes
C1:C10 = price

=SUMPRODUCT(--(A1:A10="coke"),--(B1:B10="1.5L"),C1:C10)

Better to use cells to hold the criteria:

E1 = coke
F1 = 1.5L

=SUMPRODUCT(--(A1:A10=E1),--(B1:B10=F1),C1:C10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup table 1
lookup? 1
Lookup help needed -- URGENT! Please! :) 0
Table Lookup 6
Help with LOOKUP 5
Lookup the 3rd Value 1
How to Return the value of field from two lookup? 1
Look up two values in different columns and return matching value 5

Back
Top