lookup table

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
 
A

Allen Browne

You may get a better reply if you try in the Excel group.

Lookups in Access work differently, as the relational database structure is
different to a spreadsheet.
 
Top