Formula to display data based on input

[mazahrm]

I require some help in developing a MS Excel formula, an excel worksheet to filter a list based on a code.


The excel work book has two worksheets


1 – YTD all invoices

2 - By Cost code


What is required on the Cost Code

Display Invoices from the YTD worksheet Columns A to J,

Where Input value = YTD Column A


So if the Value is entered as 3010 on the Cost Code worksheet, to lookup the value in Column A in YTD and display result in Cost Code


All help and thoughts are appreciated

 

[Hui]

Can you post a list of what columns have data in and what columns you want filled