Data Uploader - if value exists on input file, need it to update status field on source sheet
We have tracking sheet that we use to track client accounts that are transferring. I want to take a different file that shows accounts that have confirmed been transfer and use Data Uploader to have the information on the input sheet either map to or change certain cells.
I have the mapping down - but I can't figure out the formula that says "If the account number listed on the source sheet is also found on the input sheet, update the Status column". In a perfect world what I really need it to do is "If the account number listed on the source sheet is also found on the input sheet, update the Status column with EITHER 'Complete, Waiting for Download' if the Account Balance is not available(less than .01) OR update the Status with 'Complete' if the Account Balance is available (greater than .01)."
The columns on my source sheet are titled Status, Account Number and Account Balance
The column on my input sheet is titled Account Number.
Help Article Resources
Check out the Formula Handbook template!