Adding specific data from one worksheet to another

[Kimpmmr]

I'm relatively new to excel, & am having a hard time populating a cell in sheet1 with the corresponding data from worksheet2. I need to use sheet1, column B as my qualifier, & import the corresponding pricing from Sheet2 column C.
I'm sure there is an easy formula...I just cant seem to find it. Any help would be greatly appreciated.

[wk9128]

Worksheet name : sheet1
Cell D2 formula , Drag down

[Abith]

you could try using vlookup function, assuming the part numbers will not have repeated entries.

=+VLOOKUP(B2,Sheet2!$A$2:$C$20,3,0)

Just FYI, i used the formula and only the first part number, LX1005 was present in sheet 2. maybe its because of the sample data. do let know if your requirement is different.

[Kimpmmr]

Thank you for your quick response. I'm all set - the vlookup formula worked like a charm.
Thanks again!

[wk9128]

@Kimpmmr You're Welcome. Glad to help . Thank You for the feedback


If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left.