Dave
Tue May 13 18:20:38 CDT 2008
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" <petersod@verizonXSPAM.net> wrote in message
> news:482A191F.190FA186@verizonXSPAM.net...
> > 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