+ Reply to Thread
Results 1 to 4 of 4

Lookup value across multiple worksheet and locate

  1. 11-24-2023, 07:34 AM #1
    zelda13
    zelda13 is offline
    Registered User
    Join Date
    08-15-2021
    Location
    Saudi Arabia
    MS-Off Ver
    2016 & 365
    Posts
    26

    Lookup value across multiple worksheet and locate

    I need a formula to lookup value across multiple worksheet and locate (using hyperlink formula)

    Thank you in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-24-2023, 12:12 PM #2
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Lookup value across multiple worksheet and locate

    Try this in C1 and copied down.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-25-2023, 11:35 PM #3
    zelda13
    zelda13 is offline
    Registered User
    Join Date
    08-15-2021
    Location
    Saudi Arabia
    MS-Off Ver
    2016 & 365
    Posts
    26

    Re: Lookup value across multiple worksheet and locate

    Quote Originally Posted by windknife View Post
    Try this in C1 and copied down.

    Please Login or Register  to view this content.

    Perfect!
    Your help is greatly appreciated.
    Reply With QuoteRegister To Reply
  4. 11-26-2023, 12:45 AM #4
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Lookup value across multiple worksheet and locate

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. lookup an column and locate the first value greater than 0 and return the hh:s
    By superpurple in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2022, 08:07 AM
  2. Need formula to locate a value in another worksheet
    By felio in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-12-2020, 07:31 AM
  3. macro to locate locate text string and copy/paste offset range
    By guystanley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2014, 08:46 PM
  4. program or function to lookup and locate typed in data acroos multiple workbooks
    By jordanemig in forum Excel General
    Replies: 1
    Last Post: 06-12-2014, 07:58 PM
  5. VBA to locate different worksheet to last saved
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2014, 11:34 AM
  6. Locate worksheet according to specific value
    By justinng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2010, 01:51 PM
  7. INDEX(MATCH using value from one worksheet to locate data in another worksheet
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-16-2009, 04:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1