LOOKUP from separate sheet

Hi there,

First post on here so Hi!! to everyone

I feel as if I am banging my head against a wall with Excel right now, as I cannot seem to get this function to work!

Basically, I need to be able to type a value into one of the fields, in this case a part number, and the rest of the details will have to be looked up from a seperate table and enter into the remainder of the fields.

For this case, I have put the worksheet that I wish to copy the data from into the same workbook as the sheet I wish to copy the data to, to make things easier for now, ha!

I have attached an image to show what I mean!

Part number is top left of the screen. The blank fields are the ones I require to be filled in!

This is the sheet I am copying data to.

\1

This is the sheet I am copying data from.

\1

Any help would be greatly appreciated!!!

Thanks,

Nick