Results 1 to 6 of 6

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

Threaded View

Brentguthrie96 Excel help: IF TRUE, display... 05-09-2021, 01:38 PM
Limor_OP Re: Excel help: IF TRUE,... 05-09-2021, 01:43 PM
Brentguthrie96 Re: Excel help: IF TRUE,... 05-09-2021, 03:32 PM
Limor_OP Re: Excel help: IF TRUE,... 05-10-2021, 01:39 AM
setafer553 Re: Excel help: IF TRUE,... 07-27-2021, 12:17 AM
bebo021999 Re: Excel help: IF TRUE,... 05-09-2021, 10:29 PM
  1. #1
    Registered User
    Join Date
    05-09-2021
    Location
    Mississippi
    MS-Off Ver
    2104
    Posts
    2

    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.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-16-2018, 06:07 AM
  2. [SOLVED] Formula Help - Searching specific values in a row and returing true/false
    By Mikeyc85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2016, 06:22 AM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. [SOLVED] Return True/False by searching a value in an array of string
    By aiyathomas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-30-2013, 12:35 PM
  5. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  6. [SOLVED] If Function is False continue to check row below for true value
    By BearsBikes in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-26-2013, 10:02 PM
  7. Compare two excel files and display true or false
    By sravanthi009 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-01-2011, 11:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1