Using lookup function on multiple rows and columns

[Trout]

I am making a spreadsheet calculator
Using a drop down menu there are 10 choices for 'Characters'
Depending on the 'Character' selected, there are 30 different 'Options'
Next to the 'Options' will be value.

Data is layed out like so: (example)
Character (Drop down menu)
Upgrade options (Drop down, from possible options below, depending on which
character is selected[uses HLOOKUP]) Value Field (This should change value
depending on the option selected)

(Data)
Charater 1 Value Character 2 Value Character 3 Value
Option1 154 Options1 102 Options1 31
Option2 14 Options2 1 Options2 35
Option3 15 Options3 124 Options3 34

The 'character' and 'Upgrades' drop downs work fine, however the 'values'
field does not. The value field should check what "Upgrade Option" is
selected, find it in the table (not just search the top column or left row),
and then give me the value to the right of it. I have tried using a
combination of VLOOKUP and HLOOKUP and got errors. I've been sitting in front
of my PC pondering this for hours and cannot think of a solution. I have
Office 07, but it needs to be 100% compatible with 03.
This is my first time posting here so apologies if I did something wrong,
but any help in resolving this issue would be greatly appreciated. If it
makes it easier I can link to a download of the file.

 

[Jacob Skaria]

A1:J10 is the data range

A11 is the Character selected
B11 is the Option selected
In C11
=VLOOKUP(B11,A1:J10,MATCH(A11,A1:J1,0)+1,0)

Make sure the spellings are exactly same as mentioned in the drop down..In
the example you posted 'Charater 1' is ***missing a c***...

If this post helps click Yes

 

[Trout]

Thanks for the reply, however after toiling for hours I managed to figure it
out.
It's too difficult to explain here however a range of cells use HLOOKUP and
then another range of cells VLOOKUPs that range.

The spreadsheet template can be found at
www.alice40k.tripod.com
and is called LIST MAKER: Template V1.06

thanks again