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