Cell drop down selections, cell linking, and interpolating

[svbmbs169]

I am trying to make a spreadsheet for selecting the appropriate produc
based on user inputs. When the user inputs certain criteria th
spreadsheet should automatically correlate those inputs to anothe
corresponding data range that are arranged according to the inputs. A
that point, the spreadsheet should use the referenced data and anothe
user specified input to interpolate and output a result. I've attache
the file I'm working with for clarity.

As you can see in the attached spreadsheet, I want a user to be able t
enter the coil and furnace models from a drop down menu and specify th
desired airflow. The spreadsheet should automatically referenc
corresponding data for each model. From there, I want the spreadshee
to output the interpolated data result (external static pressure) fo
each variation of the specified furnace model (for each speed tap
based on the specified airflow. Also, I want the spreadsheet to outpu
corresponding data (pressure drop across the coil) based on th
specified coil model and the specified airflow. If the airflow i
outside the range available for the coil and furnace models, th
spreadsheet should return some sort of error.

Sorry if this is unclear, but the attached spreadsheet should clarif
things. Thanks in advance for any and all help. Hopefully someone ca
get me on my way with this.

Bill

Attachment filename: coil selector.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61000

 

[Mark E. Philpot]

Hi,
What a complex question you ask.
I am going to work on this for you. Could you send me your
real email address so I can send the results. I will
probably use a userform.

You can view some of my handiwork at:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

Hope to hear from you soon

regards
Mark

 

[svbmbs169]

Mark,

Thanks for your help. I e-mailed you at the Yahoo address I found on
your Geocities page. Please let me know what you figure out.

Billy