I don't think you can do this with drop downs but if you are willing
to modify your data layout, you can mimic what you describe below by
using a pivot table.


Try this:
1) transpose the months (0-12, 13-24...) from a column to a row
2) Select all the data, go to Data - Pivot Table and Pivot Chart
(follow the steps to create a pivot)
3) Finally, add the name field as a row and the 2 column fields as
columns and add the numbers you want to return to the data area.

you can then use the drop downs in the pivot to filter the data as you
describe below.




On Jul 10, 2:50*pm, SD125 wrote:
Hi all,

Using MS Excel 2003, I have a table which includes a list of names down in
column A, then across the top row is a group of 5 values (0-10,11-20,21-30
etc), the following row then has each of these lists split into 3 further
groups within each of the above groups (0-12,13-24,-25-36 - these are for
months).

The rest of the table is filed with numbers which would be read against
which name and group it fitted into.

My query is:

Is there a way that I can use drop down lists to select each of the outcomes
from the table (eg the name, between 11-20 and then 12-24) and then they tell
me the value of the cell which the would equal.

I would like to know if there is a specific formula which can be used for
this.

Many thanks in advance.

S