VLOOKUP Question

[Ed]

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]

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

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.

 

[Ed]

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]

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