I'm trying to get some data from one tab into another tab and placed in the
right position.
My spreadsheet is layed out as followed

Tab 1 (a list of every single part numebr we use)
From cell A2 all the way down to line 10000, is a list of item numbers
From cell B2 all the way down to line 10000, is a list of item descriptions

Tab 2 (a list of all the current open orders)
From cell A2 all the way down to line 2000, is a list of vendor names
From cell B2 all the way down to line 2000, is a list of purchase orders
From cell C2 all the way down to line 2000, is a list of item numbers
From cell D2 all the way down to line 2000, is a list of dates
From cell E2 all the way down to line 2000, is a list of outstanding numbers
From cell F2 all the way down to line 2000, is a list of Order quantities

Whats I'm after is data from Tab 2 to populate into Tab 1 against the
relevent item number line

Is this possible with a Vlook up and do i need to change the layout of the
spread sheet in any way.
Kind Regards

Shane