Hi,
I've got lots of data ordered differently on different spreadsheets that I want to merge onto one excel sheet. Is there a formula I can create to do a lookup for a column header in the top cell and if it matches, return the data beneath?
Thanks
Tim
Last edited by tim-harrison; 02-05-2013 at 02:30 PM. Reason: adding attachment
Suggest you post a spreadsheet with some sample data and explain the expected results.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Tim,
Welcome to the forum.
You can use match with vlookup / index / offset to achieve the desired result. Try that and if stuck, upload a sample workbook. thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I've uploaded an example that will hopefully make it clearer.. although there are many more fields in relaity I can't publish the actual spread sheet. I'm not sure how I'd write the formula, can you assist?
Am very grateful for the help!
Tim
Hi Tim,
Use below formula:-
Formula:
Please Login or Register to view this content.
example(1).xlsm
Regards,
DILIPandey
<click on below * if this helps>
thanks - that's perfect!
you are welcome time... cheers
suggest you to mark this thread as [SOLVED].. thanks.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks