3 dimensional formula? PLEASE HELP :-)

[sherri watkins]

I need some help pulling data from a table array. I have several worksheets within the workbook and need some help with a formula. See the example below.

Model: N 60-G
Pressure: 45
Discharge Pressure: 145
Capacity: XXXXX
Drive Motor:
Approach Temperature:


I need the formula to look at which model number, pressure and discharge pressure is selected and return a value from a table array on a separate worksheet. See below...

N 60-G 45 75 110 145 190
145 7.1 12 18.4 N/A N/A
215 5.7 10.9 17.3 24.0 N/A
290 N/A 9.5 16.3 22.6 30.7
360 N/A N/A 14.8 21.2 29.0
435 N/A N/A 13.4 19.8 27.9
500 N/A N/A 12.4 18.7 26.5
580 N/A N/A N/A N/A N/A
650 N/A N/A N/A N/A N/A

Thanks for your help!!

[JohnTopley]

Can you post a small sample file showing expected result(s).

[ChemistB]

So each model has a different table? All tables together down the sheet or do they vary in size? An example workbook would help a lot towards coming up with a formula (Go Advanced>Manage Attachments)

Looks like maybe INDEX/MATCH or OFFSET/MATCH

[JohnTopley]

With your table in A1:F9

=INDEX($B$2:$F$9,MATCH(K1,$A$2:$A$9,0),MATCH(J1,$B$1:$F$1,0))

j1=45 (Pressure)

k1=215 (Discharge Pressure)

A1="N 60-g" model

I assume there is a table per model (?) so need to know how data is arranged to get the correct "model" table in the final soution