Dear friends,
Hope you all are doing good, thanks for my last post replies which helped me a lot in saving my time.
I have a small query now where I want to get the data from one worksheet to another worksheet when the criteria in both the spreadsheets match.
For example On sheet - 1 I have blank table with dates as rows and names as columns. So in sheet two I have one table with total no of calls answered by team members as per dates.
So I am not under standing the match, Index formula to get the data correctly, can some one give the formula how to get the data from other sheet where the criteria match.
For example Cell D5, should get the calls answered by Mike on 01/04/2014 (both name and date criteria should match)
Hope you all are doing good, thanks for my last post replies which helped me a lot in saving my time.
I have a small query now where I want to get the data from one worksheet to another worksheet when the criteria in both the spreadsheets match.
For example On sheet - 1 I have blank table with dates as rows and names as columns. So in sheet two I have one table with total no of calls answered by team members as per dates.
So I am not under standing the match, Index formula to get the data correctly, can some one give the formula how to get the data from other sheet where the criteria match.
For example Cell D5, should get the calls answered by Mike on 01/04/2014 (both name and date criteria should match)
