Variables in Functions?

[Tony]

Hi, a newbie here.

Table description:
Row1 = SCFM values
ColumnA = Air Pressures
B2:E4 = range for Tube Sizes
A B C D E
1 50 100 150 200
2 40 0.25 0.5 1 2.5
3 60 0.125 0.25 0.75 1
4 80 0.125 0.375 0.5 2

Based on 'Air Pressure' and 'SCFM' value, I need to select
the corresponding 'Tube Size'.

I ran the LOOKUP wizard and viewed the formula which
pointed to the tube size:
=INDEX($A$1:$E$3, MATCH(G9,$A$1:$A$3,), MATCH
(H9,$A$1:$D$1,))

How can I make this variable. In other words, for a
given 'Air Pressure' and 'SCFM' the 'Tube Size' is
returned. The formula created by the wizard is static.

TIA

 

[Frank Kabel]

Hi
if you place your lookup values in the cells G9 (SCFM value) / H9 (Air
Pressure) this formula is dynamic:
=INDEX($A$1:$E$4, MATCH(G9,$A$1:$A$4,0), MATCH(H9,$A$1:$D$1,0))

now just change G9 / H9

 

[Aladin Akyurek]

=INDEX($B$2:$E$4,MATCH(G9,$A$2:$A$4,1),MATCH(H9,$B$1:$E$1,1))

where G9 houses an air pressure value and H9 a SCFM value.