• 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.

Pull data from another tab via Array based on Criteria and Different Column Order

Thanks for the help in advance. Attached is the document for support.

I am trying to pull the invoice history data into the Aptitude based on the selection in D1 (GPO Name), and the columns are in a different order than the original invoice history. It need to pull through based on the Aptitude template page.

I created a tab that show the output example but I want it to be more automated / dynamic using the array.



  • Fee Template.xlsx
    512.4 KB · Views: 6