I need help with a simple vlookup formula
 

I have a workbook with two worksheets in it

worksheet A contains (starting in row 2)

A - Product ID
B - Part Number
C - List Price
D - Customer Price

worksheet B contains (starting in row 2)

A - Part Number
B - Price

I need to put a formula in the customer Price cell of worksheet A that
will lookup the matching part number in worksheet B and use the price
in cell b of worksheet B to populate cell d of worksheet A.

I get daily price updates from a vendor daily and need a way to update
prices on over 4,000 products with the updates they send me.

Thanks in advance,

Sincerely

pj


--
phjohnso
------------------------------------------------------------------------
phjohnso's Profile: http://www.excelforum.com/member.php...o&userid=37403
View this thread: http://www.excelforum.com/showthread...hreadid=571140

I need help with a simple vlookup formula
 

Assuming Worksheet B is in the same workbook as Worksheet A this should
work:

In column D of worksheet A

=VLOOKUP(B1,Worksheet B!A1:B65535,2,TRUE)

and copy the formula down the D column


Remember Worksheet B must be in ascending order


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=571140

I need help with a simple vlookup formula
 

Try this:

=VLOOKUP(B2,SheetB!$A$2:$B$4000,2,0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"phjohnso" wrote in
message ...

I have a workbook with two worksheets in it

worksheet A contains (starting in row 2)

A - Product ID
B - Part Number
C - List Price
D - Customer Price

worksheet B contains (starting in row 2)

A - Part Number
B - Price

I need to put a formula in the customer Price cell of worksheet A that
will lookup the matching part number in worksheet B and use the price
in cell b of worksheet B to populate cell d of worksheet A.

I get daily price updates from a vendor daily and need a way to update
prices on over 4,000 products with the updates they send me.

Thanks in advance,

Sincerely

pj


--
phjohnso
------------------------------------------------------------------------
phjohnso's Profile:
http://www.excelforum.com/member.php...o&userid=37403
View this thread: http://www.excelforum.com/showthread...hreadid=571140

I need help with a simple vlookup formula
 

perfect - thanks for the help

sincerely

pj


--
phjohnso
------------------------------------------------------------------------
phjohnso's Profile: http://www.excelforum.com/member.php...o&userid=37403
View this thread: http://www.excelforum.com/showthread...hreadid=571140