I have a spreadsheet which I want to find out the latest buy price from a list.
So basically I have in Sheet 1, Column C with the suppliers name and Column D Suppliers Ref (their reference number for that product).
In sheet 2 I have a list of invoices with 4 columns, Column A Supplier, Column B Date, Column C Suppliers Ref, and Column D the price.
The formula resides in sheet 1 and should look up its supplier and supplier ref with sheet 2 and then provide the latest price from column d using the date in column B.
I currently have
=INDEX(Invoices!D:D,MATCH(1,(Invoices!A:A='Profitability Sheet'!C3)*(Invoices!C:C='Profitability Sheet'!D3),0)*(MAX(Invoices!B:B)))
Any help would be muchly appreciated.
Bookmarks