FICO Movement Problem - Vlookup, If, ISNA PLEASE HELP!

Hello All,

I need help in this FICO movement problem (See Attached). The problem is to see how accounts in each FICO bucket moved from November 2012 to March 2015. In my "Working On" tab, i seem to have the the right logic but somehow the numbers are reversed. Highlighted in Yellow on the 'Working on Tab', "Payments Made Through March 31,2015" should match the total accounts to "NUMBERS TO MATCH PAYMENTS MADE THROUGH MARCH 31, 2015" of 3,168 My formula is most likely wrong or else these would have matched.

Please help, I will give positive feedback to any that can solve my issue.

Thanks!

Hendrix

Hello Simurui,

Yes you did Simurui! Thank you, however The data set is in the tab for "Payments Made Through March 31,2015" is in the "WA -2012-B March 2015" tab (sorry this source was from another spreadsheet but the numbers are the exact same), note that I have hidden sorted out all the foreign accounts (as I didnt need foreign info). There is definitely a formula to have the 3,168 match the bottom number. Can you please help with this?

Thanks so much!

Hendrix

The FICOs are under the "Category" column in the March 2015, I added the "In November" column to see if the accounts were added, but obviously I am getting the wrong number