Linking Inputs from a dropdowm menu to a table

G

GrantM

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

Biff

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
 
G

GrantM

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