Hello,
I m downloading the dump from system which is having multiple column headers and every time these header will not come in the order. So, i m not able to apply formula. Please help me in getting the required header data based on the column header. Here i have attached the sample data with dump and expected result in output sheet.
Pls look into this and help.
Try something like this in A2:
=INDEX(Dump!$A:$G,ROW($A1)+1,MATCH(A$1,Dump!$A$1:$G$1,0))
Drag it to the right and then down as far as needed.
I would change $A:$G to a smaller range such as $A$1:$G$1000 but I'll leave that to you.
Is this what you are looking for?
Yes....Thanks a lot for your immediate help....
You're welcome. Thanks for the rep!
If that solved your question, please mark this thread as SOLVED.
Hello,
If in the Dump sheet header name is "Continent" but in my output sheet it is "Continent Name", How can i get the details with the above formula without making the unique header name...pls guide.....if this works then this would really help me to get the most of the data by mapping the header..
In A2 of the 'Output' sheet, try this:
=INDEX(Dump!$A:$G,ROW($A1)+1,MATCH(IFERROR(LEFT(A$1,FIND(" ",A$1)-1),A$1),Dump!$A$1:$G$1,0))
This formula looks for the first word in the header of the 'Output' sheet and compares that to the headers of the 'Dump' sheet.
Can we do the mapping for each header and get the results, because many of the column header in the dump doesn't match with the header in output sheet.
For Eg; I have a header name as "Associate" in dump where as i have "User Name" in my output sheet. In such cases it will not work..
Last edited by anwitha; 10-16-2017 at 09:55 AM. Reason: chge
Create a table somewhere that maps the column headers an one sheet to the other, then use this with a VLOOKUP or INDEX MATCH.
EVEN BETTER: Give the columns matching headers!
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have given the expected result in the attached sheet with mapping details. Pls help if anyone can get this requirement with formula.
You need to add continent to your mapping table, even though it's the same, then use this:
=INDEX(Dump!$A$2:$G$4,ROW(),MATCH(INDEX($I$4:$I$7,MATCH(A$1,$K$4:$K$7,0)),Dump!$A$1:$G$1,0))
copied across and down.
Now this really works awesome...thanks a lot.
Yes, it sure does - I've learnt a helluva lot since being a member here.
Glad to have helped!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks