• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to display data based on input


New Member
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


Excel Ninja
Staff member
Can you post a list of what columns have data in and what columns you want filled