Beeyen
asked on
Index formula - using two columns to match
Good Day Experts,
I have a MS Excel 2010 workbook (attached) with two speadsheets (Groupdates andGroupMemberCount) in which I wanted to match the totals from GroupMemberCount to Groupdates. I am using the Index function. However, the IFERROR does not always remove the #N/A. Would you know why?
Also, I searched the two spreadsheet and the groups do show in both spreadsheets and is returning the right number per the match in the total column from one spreadsheet to the other. But for the same group with a different account the number may be different, how can I rewrite the index formula to return the right total based on the account and the group column.
Thanks
Groups-for-Index.xlsx
I have a MS Excel 2010 workbook (attached) with two speadsheets (Groupdates andGroupMemberCount) in which I wanted to match the totals from GroupMemberCount to Groupdates. I am using the Index function. However, the IFERROR does not always remove the #N/A. Would you know why?
Also, I searched the two spreadsheet and the groups do show in both spreadsheets and is returning the right number per the match in the total column from one spreadsheet to the other. But for the same group with a different account the number may be different, how can I rewrite the index formula to return the right total based on the account and the group column.
Thanks
Groups-for-Index.xlsx
ASKER
Good Day Saurabh Singh Teotia
Look good but long. In your example why aren't the totals picked up for line10, 12, & 13?
Look good but long. In your example why aren't the totals picked up for line10, 12, & 13?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Saurabh...
Groups-for-Index.xlsx