Macro VLOOKUP needed - fetching data from part numbers

[gotze]

Hi all,

I'm pretty new to Macros and need some help with what I believe is a very simple VLOOKUP task.

On sheet 2 I have a huge list of items with prices and part numbers. On the first sheet I want to be able to type a part number, and then have the vlookup pull up information from the big list and subsequently from the row that the particular part number is featured on.

Thanks a lot in advance for reading and I look forward to your responses!