View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KP@RG KP@RG is offline
external usenet poster
 
Posts: 2
Default referencing a value from a chart with 3 variables

Is it possible to have a value (that doesn't seem to have a simple
mathematical formula) appear in a cell from a chart that is dependent on 3
variables? More specifically, a pressure rise is obtained from a chart.
This value for the pressure rise depends on the specified model of heater
used, the specified cubic feet per meter, and the specified temperature rise.
I want to have the value of the pressure rise automatically appear when the
other three values are entered from drop down lists. Help me if you can.
Thanx