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.