I have four sheets in my workbook. Three of the sheets are named after the
product that they represent. In those sheets I have the quality of the
product (1-10) and the cost for that quality. On my first sheet, I want to
be able to pick the product from a drop down menu, state the quality, and
have it return the price. I am able to use vlookup to get the price, but I
want to know if there is a way that I can specify which sheet it comes off of
with the drop down menu.

Thanks for any help.

I'm not sure why you mentioned pivot tables in your subject line, but
perhaps I'm missing something.

If you have a product name in cell B4, and a quality number in cell C4,
you can use the following formula to return the cost from a lookup range
on the appropriate product sheet.

=VLOOKUP(C4,INDIRECT("'"&B4&"'!$A$2:$B$11"),2)

Jon1205 wrote:
I have four sheets in my workbook. Three of the sheets are named after the
product that they represent. In those sheets I have the quality of the
product (1-10) and the cost for that quality. On my first sheet, I want to
be able to pick the product from a drop down menu, state the quality, and
have it return the price. I am able to use vlookup to get the price, but I
want to know if there is a way that I can specify which sheet it comes off of
with the drop down menu.

Thanks for any help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks that is what I was looking for.

"Debra Dalgleish" wrote:

I'm not sure why you mentioned pivot tables in your subject line, but
perhaps I'm missing something.

If you have a product name in cell B4, and a quality number in cell C4,
you can use the following formula to return the cost from a lookup range
on the appropriate product sheet.

=VLOOKUP(C4,INDIRECT("'"&B4&"'!$A$2:$B$11"),2)

Jon1205 wrote:
I have four sheets in my workbook. Three of the sheets are named after the
product that they represent. In those sheets I have the quality of the
product (1-10) and the cost for that quality. On my first sheet, I want to
be able to pick the product from a drop down menu, state the quality, and
have it return the price. I am able to use vlookup to get the price, but I
want to know if there is a way that I can specify which sheet it comes off of
with the drop down menu.

Thanks for any help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome. Thanks for letting me know.

Jon1205 wrote:
Thanks that is what I was looking for.

"Debra Dalgleish" wrote:


I'm not sure why you mentioned pivot tables in your subject line, but
perhaps I'm missing something.

If you have a product name in cell B4, and a quality number in cell C4,
you can use the following formula to return the cost from a lookup range
on the appropriate product sheet.

=VLOOKUP(C4,INDIRECT("'"&B4&"'!$A$2:$B$11"),2)

Jon1205 wrote:

I have four sheets in my workbook. Three of the sheets are named after the
product that they represent. In those sheets I have the quality of the
product (1-10) and the cost for that quality. On my first sheet, I want to
be able to pick the product from a drop down menu, state the quality, and
have it return the price. I am able to use vlookup to get the price, but I
want to know if there is a way that I can specify which sheet it comes off of
with the drop down menu.

Thanks for any help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html