Excel help: IF TRUE, display something. IF FALSE, continue searching the column until TRUE

Hey there, I am trying to make a table that searches through an entire column and only populates consecutive cells of ANOTHER column if the true statement is met (IE, it does not return a FALSE or a blank - it simply continues to search the column until that statement is true, and then returns something in the next cell.

Here is my example: I want the two columns J and K to search the entire columns under C and D to return a value ONLY if the condition is met (that condition being C has "Bench Press (BB)" and E has "5x5). I've gotten that far with
J: =IF(AND(E4="5x5",C4="Bench Press (BB)"),D4,"")
K: =IF(AND(E4="5x5",C4="Bench Press (BB)"),B4,"")

These conditions are met in row 4 AND row 11, which is why there were values returned in columns J and K. In row 5, however, the conditions are both not met so it returns a blank value due to my code. How can I, instead of returning this blank value, have the code continue to search columns C and E for the conditions to be met, therefore returning J11 and K11, instead in J5 and K5.

hello,
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

belinda200 what exactly are you talking about? I did exactly as you mentioned, but there were no instructions at the top of the screen, just the option to "upload file" which is what I did

Originally Posted by Brentguthrie96

belinda200 what exactly are you talking about? I did exactly as you mentioned, but there were no instructions at the top of the screen, just the option to "upload file" which is what I did

Post a small Excel sheet (not a picture)

Answers based on IF TRUE.
Conclusion: False if blank, true if text is found.
Excel does not search through the entire column until it finds a match for the given value. When an evaluation like this one is triggered by Excel conditional formatting, Excel will only evaluate cells in the column and row where the formula was typed for that particular row or column's data at that moment. That means you can do things like use a "not" sign and a cell reference to make exceptions in your formulas, which would cause calculations to stop just after finding those exceptions. Say, for example, you've put some extra calculations into your spreadsheet input as IF FALSE (risk-adjusting certain variables) then it