Hello,
I need a little help retrieving data from one sheet and arranging it correctly into another.
On the attached spreadsheet the first page will display a list of purchase order quantities by supplier and material.
The material description is listed in A3.
The data is in the sheet called 'Flight'. What I would like to happen is:
On the 'Purchase Order Table' sheet column C shows a list of week numbers. On the 'Flight' sheet rows K5 to X5 show week numbers.
K6 to X6 displays all the order quantities.
I need a formula to look up the description in A3 on the 'Purchase Order Table' sheet, find it in column D of the 'Flight' sheet then look across and match the order quantities against the correct week number and then return the correct quantities against the correct week numbers in the 'Purchase Order Table'.
Any ideas?
I've mashed up a formula from a previous exercise but it's not worked at all!
Bookmarks