Hello,
In the attached database I have a table called "Table1". In that table there's a column that lists some Account Numbers (5th column from the left). I'm trying to come up with a query/formula that searches each account number, to see if it's listed in the DRIPCash table (also provided in the database). If the account number is listed then the word "Cash" needs to appear in the corresponding account number's row in the DRIP Election column in Table 1 (towards the end of the table). If the Account in Table 1 isn't listed in the DRIPCash table, then the DRIP Election column should read "Reinvest" for that account. I was thinking some sort of nested =IIF statement. Like, if true (and the account is listed) show "Cash", if false then "Reinvest". But i'm all ears if there's a better way.
Right now the DRIP Election column is completely blank in Table1. The end result should look exactly like the table does, with the one exception of the DRIP Election column being populated with either "Cash" or "Reinvest", based on if the account number appears in the DRIPCash table or not.
Hopefully this makes sense.
Thanks so much!
Reply With Quote