Multiple drop-down lists to get a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, this may get slightly confusing, but I will try my best to describe the
problem clearly:

I have 4 worksheets that list different types of piping. Within each of
these worksheets, I have different types of fittings along with different
sizes for each of the fittings. So, my 4 worksheets look like this, each with
a differing name for the TYPE of PIPING:

"TYPE OF PIPING"
1 A B C D
2 Size1 Size2 Size3
3 -TypeA X X X
4 -TypeB X X X
5 -TypeC X X X ...etc


The problem I am having is that I create the 3 drop-down lists for 'Type of
Piping', 'Type of Fitting', and 'Size' but I have no idea how to write the
formula to pull the information I need.

I need Excel to see what was picked in the first drop-down list to go to the
worksheet, then what was picked from the second drop-down list to go to that
row, and then what was picked from the thrid drop-down list to go to that
column, and give me that number.

If you need more specifics, please let me know what I can tell you to help
you understand more. As I stated, I know it must be confusing to read, but
any help will me greatly appreciated.

Thanks,
PC
 
Just to clarify:

I'm trying to create another worksheet with the 3 drop-down lists I
described. So I want my new worksheet to look like:

A B C
D
1 Type of Pipe Type of Fitting Size ANSWER
2 Drop-down Drop-down Drop-down XX
3 Drop-down Drop-down Drop-down XX
4 Drop-down Drop-down Drop-down XX
...etc


Where picking things from the lists will give me the number from the
corresponding worksheet.

Thanks,
PC
 
From that site, what is it I'm looking for exactly? VLookUp stuff? or Data
stuff? Which link would be the most helpful?

Thanks,
PC
 
There are 18 'Data Validation' topics, and I've been through about 10 that I
thought were the most on topic. Am I skipping something? I believe my problem
is a little more complicated than what this site shows, so any extra pointers
would help me greatly.

Also, I replied to my own post with a better description of what I'm going
for. I'm sorry I'm just not getting this, but like most at this board, I'm
not the most excel-friendly person.

Thanks again,
PC
 
I did one like this recently for a client where the 2nd list is a defined
name based on what is selected in the first drop down. This could go on and
on and on, if desired.
 
Back
Top