Is this what you mean - using INDEX MATCH combination?
Is this what you mean - using INDEX MATCH combination?
It looks like it could work but doesn't give me the right information in the right columns as I want the data for AGENTTIME in the corresponding column and so on. Does MATCH work on column numbers or does it match the string in that cell? I need it to match the text due to the columns changing place in the sample worksheet.
I should've also explained the sample worksheet better, the seperate numbered tabs are the days e.g. 1st, 2nd, 3rd etc of the month and the second worksheet will be the one that will have the formulas looking up the data in similar numbered tabs. I've attached both of the workbooks this time so you can see the result I'm looking for.
I tried following the formula that you put in the attached file and it had the wrong data in the wrong columns which is the same as what's happened in the example you attached.
Thanks
EDIT: Ignore this after some tweaking I managed to get it working I just had to edit the cells it was starting at in order for it to select the right one. So this is now solved. Thanks
Last edited by Alexvs; 11-09-2010 at 06:41 AM. Reason: Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks