Excel 2007 : Drop Down List and copy adjacent cell

[rcarbs]

Hi, I need some assistance. I'm making a service price list. I know how to make a drop down list but I don't know how to copy the Cost($) of the corresponding part to the first sheet. Sample below.. Please help Thanks!

Sheet 1

Part#	Cost
"Drop Down list for Part# from Sheet2"	"Copy the part cost from Sheet 2"
Seal#44448888	$18.00

Sheet 2

Part#	Parts Cost
Filter#12345678	$20.00
Seal#44448888	$18.00

[Pete_UK]

Try this:

=VLOOKUP(A2,'Sheet 2'!A:B,2,0)

Hope this helps.

Pete