formula to compare a values and return

Discussion in 'Excel' started by DSnuh, Mar 25, 2015.

  1. DSnuh

    DSnuh

    Joined:
    Mar 25, 2015
    Messages:
    2
    Likes Received:
    0
    I'm looking for a formula to compare text in one specific cell with information in a range of cells within a column. If the text in the original cell matches and of the information in the column of cells, then display a "found"... if not display "not found".

    EXAMPLE
    original cell = 25
    column of cells are random numbers
    if it finds 25 in the column, then return "found"
    if it does not find 25 in the column, then return "not found"
     
    DSnuh, Mar 25, 2015
    #1
    1. Advertisements

  2. DSnuh

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    If the value is entered in B1, one formula would be:

    =IF(ISERROR(SUBSTITUTE(ADDRESS(MATCH(B1,A:A,0),1),"$","")),"not found",B1&" was found in cell "&(SUBSTITUTE(ADDRESS(MATCH(B1,A:A,0),1),"$","")))

    Note that this formula will give the cell reference for the first occurrence of the entered value.
     
    XLPadawan, Jun 15, 2016
    #2
    s.arumugam likes this.
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bvclsaaal

    Compare 4 columns & find dissimilar

    Bvclsaaal, Jul 2, 2011, in forum: Excel
    Replies:
    1
    Views:
    613
    XLPadawan
    Jun 15, 2016
  2. tskelton75
    Replies:
    0
    Views:
    615
    tskelton75
    Nov 16, 2011
  3. tskelton75
    Replies:
    0
    Views:
    254
    tskelton75
    Nov 16, 2011
  4. Nago
    Replies:
    0
    Views:
    532
  5. CarolB
    Replies:
    2
    Views:
    949
    XLPadawan
    Jun 15, 2016
  6. David92595
    Replies:
    1
    Views:
    719
    lcaretto
    Jul 25, 2012
  7. phdman
    Replies:
    1
    Views:
    486
    Kevin@Radstock
    Nov 2, 2012
  8. marste7

    Copy and Paste Formula

    marste7, Aug 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    727
    XLPadawan
    Jun 16, 2016
Loading...