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,RA NGE,0))

Biff

-----Original Message-----
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.
.