Compare numbers on 1 tab to other tabs in workbook.

Excel Discussion in 'Microsoft Office' started by MELISSA68, Mar 12, 2018.

  1. MELISSA68

    MELISSA68

    Joined:
    Mar 12, 2018
    Likes Received:
    0
    I need to compare a number on tab 1 to the tabs 2& 3 in my workbook. If found-yes, if not found-no.
     
    MELISSA68, Mar 12, 2018
    #1
    1. Advertisements

  2. MELISSA68

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,395
    Location:
    Manchester
    Welcome to the forum :)

    The COUNTIF formula could be used to do this - it looks for specific criteria within a range:

    =COUNTIF(range,criteria)

    Because your range is split over two sheets, I would also use the OR function, and use the IF function to give your Yes/No result. It could look something like this:

    =IF(OR(COUNTIF(Sheet2!A1:C5,B1)>0,COUNTIF(Sheet3!A1:C5,B1)>0),"Yes","No")

    Where the green text is the cell on sheet 1 (ie the number you want to find), the red text is the range on sheet 2, and the blue text is the range on sheet 3.

    Hope this helps!
     
    Becky, Mar 12, 2018
    #2
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.