I am creating a script that takes a monthly file with account information and updates a master file based on it.
If the account exists in the master file, it should find in which row is that account in the master file and update the info in columns E and F (of the master file) with the info from the columns H and J (of the input file).
If the account does not appear, it should add the account to the first empty row of the master file, taking only the information of the columns A,B,C,E,H,J,N of the input file and setting that info to the columns A,B,C,D,E,F,G of the master file
I have trouble figuring out what to put in the THEN and ELSE conditions after getting the script to compare the first columns and identify if an account exists or not in the master file.
Any help is appreciated, many thanks!