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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

perfect - thanks for the help

sincerely

pj

Try http://analysttutorials.com/a-simple-vlookup/. It will help you learn a simple VLookup.