I have a problem with data in different alignment to the outcome I need. I have names across the top, dates down the side, and random numerical data in the middle, but want to tip the data data on the side to meet another similar table. The data I have shows in Row 1, 26 names (B1:AA1), and in Column A a series of dates of 3 years (A2:A200). I need to be able to search the names in row 1, against the names that are in another table in column A, finding the dates in column A against the dates in row 1 in the destination table, and return the appropriate answer. I've tried Index, Match, and various lookups, but can't seem to get the syntax correct.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Index, Match and Lookup Problem
- Thread starter by76
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,717
- Office Version
- 365
- Platform
- Windows
What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
Excel Formula:
=INDEX(Sheet2!B2:AA20,MATCH(B1,Sheet2!A2:A200,0),MATCH(A2,Sheet2!B1:AA1,0))
Upvote
0
Solution
