Multiple drop-down lists to get a value

[PCoyne]

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

 

[Don Guillett]

Debra can help you.
http://www.contextures.com/tiptech.html

 

[PCoyne]

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

 

[Peo Sjoblom]

http://www.contextures.com/xlDataVal02.html

 

[PCoyne]

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

 

[Don Guillett]

data validation

 

[PCoyne]

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

 

[Don Guillett]

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.

 

[Don Guillett]

Look on Debra's site for
datavalorder.xls