I have a table of values where column A starting in row 2 is parameter one which increases as the rows go down. Columns B-F in row 1 are increasing values of parameter two. Filling in the rest of the table are the results obtained with an input from parameter one and parameter two. How can I draft a lookup with two inputs, one vertical and one horizontal?
A. B. C. D. E. F.
<100 101-120. 121-140 141-160 >160
<41 3.5 3.3 3.1 3.0 2.7
42-65 3.8 3.7 3.5 3.3 3.1
66-90 4.1 3.9 3.6 3.4 3.3
91-120 4.5 4.4 4.1 3.9 3.6
121-300 4.8 4.6 4.3 4.2 3.9
301-1000 5.4 5.1 4.8 4.5 4.3
>1000 7.3 6.9 6.8 6.6. 6.5
So I want to enter, say parameter one is 72 and parameter two is 122 and get 3.6 returned.
Or enter 32 and 76 and get 3.5
thanks, Maureen
A. B. C. D. E. F.
<100 101-120. 121-140 141-160 >160
<41 3.5 3.3 3.1 3.0 2.7
42-65 3.8 3.7 3.5 3.3 3.1
66-90 4.1 3.9 3.6 3.4 3.3
91-120 4.5 4.4 4.1 3.9 3.6
121-300 4.8 4.6 4.3 4.2 3.9
301-1000 5.4 5.1 4.8 4.5 4.3
>1000 7.3 6.9 6.8 6.6. 6.5
So I want to enter, say parameter one is 72 and parameter two is 122 and get 3.6 returned.
Or enter 32 and 76 and get 3.5
thanks, Maureen