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

Lookup Type problem

Gilbert

New Member
Hi guys I've a problem with the TA data file which I'. Where i'll get 3 sheets which is the Sector file, Sectors file and Stats 7 days Aggregate file. Now I need A file which ended up like the test sheet. currently I'm doing it with the normal vlookup but this is time consuming, I need to know whether it is possible to do this using some macro. In the test sheet below are the criteria need to be done:
1. the collum D which is the Sector, we need to look up with the sector file in
order to get the value. the lookup value is the Collum E.
2. once we get the value on collum D this will be the lookup value for collum
A,B,C from the Sectors file which i have highlighted in yellow colour.

Please let me know if this can be done. thanks
 

Attachments

  • TA Data.xlsx
    411 KB · Views: 4
Back
Top