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