+ Reply to Thread
Results 1 to 6 of 6

Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    Yes folks, another one of these

    I have attached a sample sheet for perusal.

    Cheers
    hammer
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    Hi,

    The simplest way is to create a helper column F in your data sheets with the formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then in the Input in N2

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Have you considered keeping all your data on a single sheet with an extra column to hold what is currently the sheet name?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    suggestion attached
    Attached Files Attached Files
    Please consider adding a * if I helped.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    Hi Hammer

    Might I suggest that you try and explain your question IN the post, rather than just attaching a workbook and saying - look in there"? many members will look at your question, and if they think they can help, or they think it might ne interesting or challenging, they will take it further. If you have nothing got them to evaluate, they may just pass you up and move on to the next question
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    Fantastic result gents!
    Thank you both so much

    @ Mr Dibbins, surely they would not pass me up lol point taken Sir and thank you.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell

    Glad to have helped and thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell-
    By hammer2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2015, 01:48 AM
  2. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2015, 04:55 AM
  3. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2014, 11:38 PM
  4. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2014, 12:30 AM
  5. Replies: 5
    Last Post: 10-26-2014, 10:37 PM

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