+ Reply to Thread
Results 1 to 4 of 4

Lookup on another worksheet if a value from one cell is found

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    387

    Lookup on another worksheet if a value from one cell is found

    Hello,

    In the example attached.

    On Sheet2, I want to lookup matching values in column A on Sheet1 if the value on Sheet2/B1 is found on Sheet1 and return the words FOUND.

    Hard to explain, but the example attach will show what I am trying to do.

    I appreciate any help.

    Thank you,
    Nick
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Lookup on another worksheet if a value from one cell is found

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

    Or, for 365:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    which will SPILL down.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    387

    Re: Lookup on another worksheet if a value from one cell is found

    Perfect, Thank you TMS!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Lookup on another worksheet if a value from one cell is found

    You're welcome. 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] Format lookup cell based on the found cell.
    By Shaun A in forum Excel General
    Replies: 3
    Last Post: 04-16-2021, 10:37 AM
  2. [SOLVED] lookup column header based on cell value found from row name
    By mtwa1990 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2020, 02:47 PM
  3. Cell to lookup records to check if a value is found indicate the value in cell
    By michael35 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2019, 05:24 PM
  4. [SOLVED] Lookup cell contents on another workbook and replace if found
    By mainemojo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2018, 11:46 AM
  5. Replies: 4
    Last Post: 11-12-2014, 07:43 AM
  6. [SOLVED] Trying to lookup a value in a different worksheet and get Y if found, or N if not.
    By Marybh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-13-2014, 04:23 PM
  7. Lookup and move relative to cell found
    By garner.ms in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2013, 12:44 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