The original issue has been solved but now I am faced with a new issue. Although the I am able to see my accounts in the drop down, when the account is selected, the balance will not auto populate and remains blank. Balance is Column O ={“BALANCE”;arrayformula(if(isblank(L7:L),iferror(1/0),iferror(vlookup(L7:L,{AM7:AM,AR7:AR},2,false))))} under Debt Payoff Goals. The account in question is a manual account, I wonder if this somehow has an effect?
Let me know if additional information is required. Thank you in advance.
That is pretty confusing. The formula is straightforward. It should look for a match for the value in column L in column AM and then return the value of the corresponding row in AR.
What if you just drop this minimized version somewhere in the spreadsheet? =vlookup(L7,{AM7:AM,AR7:AR},2,false)
Where you replace L7 in the formula with a reference to the column L row that is failing to return a balance.
I would really focus on finding out why that single-cell VLOOKUP doesn’t work… because it should.
The formula is simple so there must be something subtle going on with the lookup that we can’t see in this thread.