I'm trying to accomplish exactly that. I am fairly familiar with these formula's and data validation. But I can not seem to put these two together and make it work.
I have several tanks listed as the type they are and in column 1 "inches", column 2 "volume for each tank. I want to have a drop down list that selects which tank, and then I can type in the inches and it presents the volume.
I am not familiar with arrays. If this is something that needs to be in a array I would need to know so I can read up and learn how to create them.
Any help would be appreciated. And if need be I would be able to attach the spread sheet to this post.