lookup values via drop-down lists

[IanJ]

Hi

I have a table of data which I want to query based on two criteria, using drop-down lists.
Criteria 1 is in rows, and criteria 2 is in columns, as follows:

1 2 3
100 a b c
200 d e f
300 h i j
400 k l m

The query table looks like this:

criteria 1 [drop-down list]
criteria 2 [drop-down list]
[value]

I think the formula for the [value] cell should be relatively straightforward, but I'm really struggling ... please help!

Ian

[VBA Noob]

Maybe this link will help

http://www.j-walk.com/ss/excel/usertips/tip020.htm

VBA Noob

[IanJ]

Thanks - that works perfectly!

Just to make life difficult, I've tried adding a third MATCH criteria, but it doesn't work - does a three-way table lookup require a different formula?

I have a sequence of 4-column tables, each table has two header rows - the first with a common value, the second with variants. I want to be able to look up data via the first and second column headers, then by row.

Hope that makes sense!

[VBA Noob]

Does this link help

http://www.excelforum.com/showthread...=594018&page=2

VBA Noob

[IanJ]

Hmmm .. makes me realise how badly my data is structured!
A bit of tidying up should mean I can stick with the two-way lookup ... thanks for your help.

[VBA Noob]

No problem

VBA Noob