help with formula
Hello everyone,
first of all, I am new to reddit in general so I hope this is the right place to post this. If not, I apologize and please redirect me to the proper subreddit.
I have recently starting a personal accounting sheet and there is something that i quite cant manage to do. I have set up a dummy file for this purpose, which is here:
I have 2 tabs for bank accounts, which look like this:
What i would like to do, is in B2 of "MAIN" tab, to select one of the accounts from the drop down list, and then for the formula to look for that specific account in the"F" column of each "BANK" tab, and return columns C, D and E, so that I get something that looks like this:
I believe its basically a VLOOKUP but i cant manage to get the result i want when the key word that it searches for is not in the first column of the range (in this case its the last column).
Thank you in advance for your help!