lookup table

  • 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
 
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.
 

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 multivalue 1
Access 2003: populate combobox with CSV values from table column 1
How to Return the value of field from two lookup? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Table lookups with queries 8
Fill in multiple fields with one lookup 0
Create New Table/Column 1
Lookup Table 6

Back
Top