+ Reply to Thread
Results 1 to 9 of 9

Formula:Checking if (A) is in one list, returning Y then checking for (A) in another list

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Formula:Checking if (A) is in one list, returning Y then checking for (A) in another list

    Ok, so i have a list of fleet numbers below


    12848
    518968
    15684
    121684

    I need a forumla to go next to these fleet numbers that does the following:

    Checks if that fleet number is listed in a list on another tab, and return Y or N.

    BUT then i also want it to look on a 3rd tab, and see if the fleet number is listed in that tab.. and if it is, say "VOR" (vehicle off road).

    Can anybody help?

    Do i need a SUMPRODUCT formula?

    15168HELP.png

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,519

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    Please post a sample file not an image.

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    Many members are unable to see images in the *.png format.

    If you need to post an image post it in the *.jpg format.

    Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    File attached
    Many thanks!


    For clarity on file i attached above... the formula in question is column H on the Summary tab.

    Column H should have "Y" if the fleet number is in tab 'DIR DIAD', "N" if not but then look if it's in the 'VOR' tab and return "VOR" if found.
    Attached Files Attached Files
    Last edited by vkz7hxy; 11-11-2015 at 09:42 AM.

  5. #5
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    End result: Column 'H' should be full of Y's and N's, and a few VOR's
    Last edited by vkz7hxy; 11-11-2015 at 09:43 AM.

  6. #6
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l


  7. #7
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,901

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    Try this formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  8. #8
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    Thanks worked perfectly!

    Any way of you explaining what you've done so i can do it in future?

  9. #9
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula:Checking if (A) is in one list, returning Y then checking for (A) in another l

    Here's another one...

    =IF(COUNTIF('DIR DIAD'!E:E,D2),"Y",IF(COUNTIF(VOR!A:A,D2),"VOR","N"))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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