Originally Posted by trebor57

here's more info to help clear things up.

I am inputing a value into cell "F4" that value is "30"
I am inputing a value into cell "G4" that value is "I"
I am inputing a value into cell "I4" that value is "3"
I am inputing a value into cell "K4" that value is "460"

these values will change based on the user and what they are looking for.

the above values will be manualy inputed into a spread sheet.

I want the formula in cell "L4" so that the data is looked up and displayed in cell "L4".

This is the table.....
I want the formula to look in column "AA" and find "30" and in row "3" and find "460 then find the intersection of the approiate column and row and return that value to cell "L4". remember the values listed above will chanke based on the criterior of the user. and the formula will look in this table and find the data they desire.

AA AB AC AD AE
induction
HP I3
115 230 460 2300
0.5 4.4 2.2 1.1 --
0.75 6.4 3.2 1.6 --
1 8.4 4.2 2.1 --
1.5 12 6 3 --
2 13.6 6.8 3.4 --
3 -- 9.6 4.8 --
5 -- 15.2 7.6 --
7.5 -- 22 11 --
10 -- 28 14 --
15 -- 42 21 --
20 -- 54 27 --
25 -- 68 34 --
30 -- 80 40 --
40 -- 104 52 --
50 -- 130 65 --
60 -- 154 77 16
75 -- 192 96 20
100 -- 248 124 26
125 -- 312 156 31
150 -- 360 180 37
200 -- 480 240 49
250 -- -- 302 60
300 -- -- 361 72
350 -- -- 414 83
400 -- -- 477 95
450 -- -- 515 103
500 -- -- 590 118



can you help?