Returning a tabled value from two inputs.

[Chris Lightowler]

I have a table as such,

Ang 4 5 7 10 15 22.5 30 45
C 0.11 0.13 0.17 0.26 0.42 0.6 0.77 0.9
R 0.13 0.14 0.21 0.35 0.53 0.72 0.83 0.92

NB: Hope the table comes through ok.

I want to create a formula that looks at two inputs, e.g.

Desired Angle of Taper = 5 (input)
Form of Duct C / R = R (input)

The formula will then return a value corresponding to the
inputted row and column e.g = 0.14

The table is just made up from values entered into plain
excel cells.

I have unsuccessfully tried using IF functions, but may be
wrong to do so due to the limit of 7 nested functions ??.

If anybody could assist me or have any ideas at all I
would be much appreciated.

Regards

Chris

 

[Paul]

I have a table as such,

Ang 4 5 7 10 15 22.5 30 45
C 0.11 0.13 0.17 0.26 0.42 0.6 0.77 0.9
R 0.13 0.14 0.21 0.35 0.53 0.72 0.83 0.92

NB: Hope the table comes through ok.

I want to create a formula that looks at two inputs, e.g.

Desired Angle of Taper = 5 (input)
Form of Duct C / R = R (input)

The formula will then return a value corresponding to the
inputted row and column e.g = 0.14

The table is just made up from values entered into plain
excel cells.

I have unsuccessfully tried using IF functions, but may be
wrong to do so due to the limit of 7 nested functions ??.

If anybody could assist me or have any ideas at all I
would be much appreciated.

Regards

Chris

Suppose you had C/R in A1 and Angle in B1, and your table (including the
headings along the top and down the left) was named "Table".
This formula will look up the value required at the intersection of the C/R
row and Angle column:
=INDEX(table,MATCH(A1,INDEX(table,,1),0),MATCH(B1,INDEX(table,1,),0))