Formula based on drop down menu selection

Hi,

Firstly I'm not overly familiar with the inner workings of Excel, I can do basic stuff and simple IF statements etc. but I'm stuck at the moment.

The scenario is:

Sheet 1 has a table of prices. There are 7 columns labelled 2 thru 8 and two rows, labelled 1 and 2. Each combo has a separate price.

Sheet 2 has a weight specification (1 or 2 referring to the rows in sheet 1) and a drop down menu with options 2 thru 8.

When I choose a number from the drop down menu, let's say 5, I want to populate another cell with the value from sheet 1 of column 5 on row "whatever the weight spec is", let's say 2.

Any ideas on how I can achieve this would be great!

A combination of INDEX and MATCH sounds like what you need here.
Post a sample workbook and I'll show you how.

BSB.