Linking Inputs from a dropdowm menu to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I link the inputs from two dropdown menus to a table, so that excel
knows from which column in a table to look for the required values? The
dropdowm menu's are independant of one another and the first contains the
place and the second contains a product.
 
Hi!

You need to post more detail about your table but here are
a couple of basic methods:

=VLOOKUP(PLACE,TABLE,MATCH(PRODUCT,RANGE,0),0)

=INDEX(TABLE,MATCH(PLACE,RANGE,0),MATCH(PRODUCT,RANGE,0))

Biff
 
Hi, thanks I will try that.

The tables are regression coefficients, and are linked to the data by the
one of the inputs(not from the dropdown menus) being betweeen two certain
values. There are about ten different ranges that the data can be between,
and about ten different regression coefficients per range. There are about 15
products at 6 different locations, each having there own regression formula
with there own ranges. ( I think I made it sound more complicated than it
actually is!)

I know how to select the required ranges, but I don't know how to tell excel
the correct column for the product.
 
You must log in or register to reply here.

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

Help With MS Access 4
VBA - how do I pass info from dropdown list to a string?? 1
Linking Mainform and subforms 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Populate Data from a table to another 0
Checking if data exists another table and, if yes, extracting a value 0
Data table with inputs from a differente worksheet 1
Complex search and replace macro based on input variables. 12

Back
Top