Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-mini-2024-07-18· OpenAIAi2 WildChat-4.8M (AI2)

FORMULA TO SEARCH FOR CELL I11 IN COLUME O:O AND RETURN TRUE IF FOUND OR RETURNT FALSE…

  1. User

    FORMULA TO SEARCH FOR CELL I11 IN COLUME O:O AND RETURN TRUE IF FOUND OR RETURNT FALSE IF NOT FOUND

  2. Assistant

    You can use the ISNUMBER and MATCH functions in Excel to check if a value (in your case, the value in cell I11) is found in a specific column (column O). The formula you can use is as follows:

    =ISNUMBER(MATCH(I11, O:O, 0))
    

    Explanation:

    • MATCH(I11, O:O, 0): This function searches for the value in I11 within the entire column O. The 0 specifies that you want an exact match. If it finds the value, it returns the relative position of that item within the range; if not found, it results in an error.
    • ISNUMBER(...): This function checks if the result of MATCH is a number (indicating that a match was found). If it is a number, ISNUMBER returns TRUE; if it is an error (meaning no match was found), it returns FALSE.

    Usage:

    Just enter the above formula in the cell where you want the TRUE/FALSE result to be displayed. If the value in I11 is found in column O, it will return TRUE; if not, it will return FALSE.