Variables in Functions?

  • Thread starter Thread starter Tony
  • Start date Start date
T

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
 
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
 
=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.
 
Back
Top