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.