Hello I am STUCK and I need help with IF and VLOOKUP formulas! Need Help!

I have profit/loss spreadsheets I am using for my business and would like for the data from my bank account (export to CSV, then excel) to automatically import the data into each cell of the profit loss sheet, based on keywords from the bank statement. The bank statement will be on a tab that is next to the Profit/Loss spreadsheet. Currently, I have to do this manually, and it takes up a lot of my time.

Example: On my workbook, I would like the data from the Bank Statement work sheet for any line item that says "DEPOSIT" to be formulated to automatically be entered into the "Total Revenue" Cell of the Profit/Loss worksheet, as well as, "AMERICAN EXPRESS SETTLEMENT" to be entered into the "Total Revenue" cell as well.

Thanks!

Thanks for the response! See attached

Wow thanks! Ok I enetered the formula and added "MERCHANT BNKCD DEPOSIT" as well, and it isnt working properly. Here is the formula
=SUMPRODUCT(((('Valley Bank '!$C$2:$C$151="Deposit")+(ISNUMBER(SEARCH("AMERICAN EXPRESS SETTLEMENT",'Valley Bank '!$C$2:$C$151)+(ISNUMBER(SEARCH("MERCHANT BNKCD DEPOSIT",'Valley Bank '!$C$2:$C$151))))*'Valley Bank '!$D$2:$D$151))))

Sorry, Yes, or ANY keyword in the column, as i will assign the formula to each different line item

You are awesome. This will be soo much easier...Thanks, Glenn!

Glenn, I have one more question that may be more complex. As I am formulating the data from the P/L sheet to pull from the bank sheet, is there a formula that can indicate (via coloring the cell, say yellow on the bank worksheet) each cell that ISNT goverened by the formula?

Example: If one month, i do a one time purchase (say a gift card at the end of the quarter for the best staff member) that comes up on my bank statement, that ISNT auto pulling into the P/L via the formula, it would then be filled yellow, similar to conditional formatting? Is this possible? Thx!!