pivot tables

J

Jon1205

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.
 
D

Debra Dalgleish

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)
 
J

Jon1205

Thanks that is what I was looking for.

Debra Dalgleish said:
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)
Click to expand...
 
Top