So I have a list of account codes in one column and the names of the accounts in the next column.
I then have a data entry table in which I enter the account code and an income amount $.
I want to make it so that a description column which follows the account number will auto populate upon entering the account code.
So it looks like this:
D6:D20 is account numbers
E6:E20 is account description
F6:F20 is income amount $
Then outside the data table I have the list of account codes and descriptions.
Codes are J3:J21
Descriptions are K3:K21
The thing I cannot figure out is how I can do an IF statement with multiple logics?
There is 15 account numbers and descriptions, the thing is the row in which they will be entered is not always going to be the same..
I mean I know the easy function if it was to always be on the same row..