Validation and data lookup from more then one variable

[teashaandrew]

Hi,
I'm currently trying to make a data form.
I've made some data validation drop down lists and also some value lookup boxes so information automatically populates based on the selection the trouble I have now is I need to create a cell, that factors on 3 other validated cells.
For example.
I have 40 different pump models, and they are in a drop down list in cell b24. This data populates 2 other cells that don't apply to the one I'm trying to do now.
Each pump model has a choice of 2 RPMs - 2 and 4. This selection also populates another cell not in relation to this.
Then each pump model has a choice of a spring base or standard, which is a drop down list.
And then each pump model, based on the RPM has a different base feet coordination.
So in simple form - if I select pump 1 from my drop down list, and then RPM of 2, and then spring - I need it to populate the base feet.

Can someone help with this - do I need another formula, or am I trying to put too much into one cell.

[aydeegee]

Hi teashaandrew

From reading what you are asking, it seems that it could be a cut down version of another problem that I solved. I am somewhat busy at the moment, and do not have the time to amend the file, but pass it on to you in its original form so you can see what can be done.

To run the process, select the filters you want and press the "Get Data" area

To see the code, press Ctrl + F8 and select "Step into".

If you can see any merit in the file, then see if you can adapt it.

I will have more time next week to look at this, so if you need help, let me have a sample of your input and required output.

Regards
Alastair

[teashaandrew]

Thanks Alastair,
I'm going to have to wait until i have a computer in front of me to view your attachment and send you through my data. Hopefully get something through this afternoon