I use VLOOKUP all the time but I now have a workbook with multiple
worksheets. Each worksheet has different product groups. Each product has a
unique product code (catalog #). I would like to retrieve three pieces of
data.

PRICE
PKG. QTY
PKG. WT

I have a master worksheet with all of the product codes.

Is there anyway I can use VLOOKUP or is there some other formula I should
use?

Thanks to all in advance.

I think 3 =vlookup() formulas would work perfect.

Ed wrote:
>
> I use VLOOKUP all the time but I now have a workbook with multiple
> worksheets. Each worksheet has different product groups. Each product has a
> unique product code (catalog #). I would like to retrieve three pieces of
> data.
>
> PRICE
> PKG. QTY
> PKG. WT
>
> I have a master worksheet with all of the product codes.
>
> Is there anyway I can use VLOOKUP or is there some other formula I should
> use?
>
> Thanks to all in advance.

--

Dave Peterson

Thank you Dave for your speedy response, but I think I need a little more
help.

What is the "3"?
Is it the # of worksheets?
Would I be able to fine more detailed help on the MS Office website?

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I think 3 =vlookup() formulas would work perfect.
>
> Ed wrote:
>>
>> I use VLOOKUP all the time but I now have a workbook with multiple
>> worksheets. Each worksheet has different product groups. Each product has
>> a
>> unique product code (catalog #). I would like to retrieve three pieces of
>> data.
>>
>> PRICE
>> PKG. QTY
>> PKG. WT
>>
>> I have a master worksheet with all of the product codes.
>>
>> Is there anyway I can use VLOOKUP or is there some other formula I should
>> use?
>>
>> Thanks to all in advance.
>
> --
>
> Dave Peterson

One =vlookup() for each value you want to return.

=vlookup(a1,'pricesheet'!a:b,2,false)
=vlookup(a1,'pkgqtysheet'!a:b,2,false)
=vlookup(a1,'pkgwtsheet'!a:b,2,false)

========
Or maybe I'm misunderstanding.

If that master sheet has all the info on it and you want to retrieve 3 values
from that single sheet:

=vlookup(a1,'mastersheet'!a:e,2,false)
=vlookup(a1,'mastersheet'!a:e,3,false)
=vlookup(a1,'mastersheet'!a:e,4,false)

Debra Dalgleish has lots of notes on =vlookup() here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

Ed wrote:
>
> Thank you Dave for your speedy response, but I think I need a little more
> help.
>
> What is the "3"?
> Is it the # of worksheets?
> Would I be able to fine more detailed help on the MS Office website?
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I think 3 =vlookup() formulas would work perfect.
> >
> > Ed wrote:
> >>
> >> I use VLOOKUP all the time but I now have a workbook with multiple
> >> worksheets. Each worksheet has different product groups. Each product has
> >> a
> >> unique product code (catalog #). I would like to retrieve three pieces of
> >> data.
> >>
> >> PRICE
> >> PKG. QTY
> >> PKG. WT
> >>
> >> I have a master worksheet with all of the product codes.
> >>
> >> Is there anyway I can use VLOOKUP or is there some other formula I should
> >> use?
> >>
> >> Thanks to all in advance.
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson