• 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

    Hui...

  • 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

mazahrm

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
 

Hui

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