Vlookup Function or perhaps there is an easier way

[mrnowah420]

So for example I have a spreadsheet with around 20000 part numbers and titles. On the first sheet they have the correct part #, but not the correct title. On the second sheet I have the same part numbers with the rite title as well with a bunch of other information which I need.

I know I could sort or somethan but that would just be to time consuming. I am pretty sure vlookup would do this for me but its been a couple years and I have totally forgot how to do it.
A b c d e f g h i j k

Item

Part #

Name

Qty

Price

Weight

Length

Height

width

Part #

Name

501007A100ABK

Frame

501007A100ABK

FRAME

<colgroup><col style="width: 100px"><col width="151"><col width="186"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
[TD="align: right"]CELL-1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]499.95[/TD]

</tbody>

So ultimately I want the Name to be the Capital Name on the Right by looking up both part numbers but the outcome being the Name (FRAME). Obviously the 20000 titles I have are way more detailed with information

 

[Oeldere]

Without showing the data, I am not able to give a good solution.

 

[snjpverma]

I would suggest you google Vlookup and use it. It is very simple. In case you are not able to do it. Then post a sample data with the desired output.