Yes, VLOOKUP very slick!
On the Feedbot, it think it depends which template your started with. Some may have an Accounts sheet. The raw data one that’s I’m mostly using does not have an Accounts sheet.
But all the Feedbot versions have a Balance History. You can also pull the latest balance in an account from there.
The VLOOKUP formula uses this format:
=VLOOKUP ( search_key , range, index, [is_sorted] )
To use this in the Balance History sheet, find a column in that sheet that uniquely identifies the account you want. It could be the Account # or Account Name. That unique information becomes the search_key. Let’s use the name My Checking Account for this example.
For the range, use the Column of that search_key and the Column of the Balances.
If searching with the Account Name and the Account Name is in C and the Balance in F, then the range is C:F.
The index is the number of columns (from C:F) where you want to look for the result. In this case, it would be 4 (C=1, D=2, E=3, F=4).
Finally, set the is_sorted value to FALSE. Then the first value will be used. Since the Balance History gets sorted by date, the top value will be the latest value.
So the VLOOKUP part would be:
=VLOOKUP("My Checking Account",'Balance History'!C:F,4,FALSE)
Give it a try with your columns.