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

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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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

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


--
Regards,

Peo Sjoblom



"PCoyne" wrote in message
...
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

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" wrote:


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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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

data validation

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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" wrote:


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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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

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" wrote:

data validation

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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" wrote:


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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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

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
SalesAid Software

"PCoyne" wrote in message
...
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" wrote:

data validation

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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" wrote:


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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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

Look on Debra's site for
datavalorder.xls

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
data validation

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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" wrote:


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

--
Don Guillett
SalesAid Software

"PCoyne" wrote in message
...
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