LinkBack URL
About LinkBacks
Just seen the workbook - I cannot see the connection between the two tables. What is supposed to have happened? How does the one on the left relate to the one on the right?
Just seen the workbook - I cannot see the connection between the two tables. What is supposed to have happened? How does the one on the left relate to the one on the right?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
the right with green row is the raw data I received.
The left the one with blue row is the one I'm working on.
The connection column from the right table has been transposed in the left table (rows C2:E2) and then I'm using the index function as mentioned above to the get the departmentcode under the store name. Hope I explained well.
Updated the sample file to understand better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks