+ Reply to Thread
Results 1 to 3 of 3

Trying to jump to a cell using Hyperlink and Match on two separate rows

  1. #1
    Registered User
    Join Date
    01-04-2022
    Location
    Cork, Ireland
    MS-Off Ver
    2016
    Posts
    2

    Trying to jump to a cell using Hyperlink and Match on two separate rows

    Hi,
    Beginner here.
    Office 2016.
    I have set up a search function using HYPERLINK which when pressed jumps to matching cell contents. The problem I am having is I would like to be able to search 2 separate Rows (7:7 and 14:14) simultaneously. The only way I have managed it is by setting up two separate Hyperlinks, one for Row 7 and one for Row 14.
    I would appreciate if someone could have a look at the attached worksheet and see where I am going wrong please. I am also open to any other suggestions that would offer a more efficient or user friendly search function.
    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    Europe
    MS-Off Ver
    Office 365
    Posts
    473

    Re: Trying to jump to a cell using Hyperlink and Match on two separate rows

    How do you envisage the logic for this? Do you mean, search for the target number in row 7, and if not found, search in row 14?

    If so, you can wrap the iferrors e.g. in cell C3 use the formula:
    Please Login or Register  to view this content.
    <<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts

  3. #3
    Registered User
    Join Date
    01-04-2022
    Location
    Cork, Ireland
    MS-Off Ver
    2016
    Posts
    2

    Re: Trying to jump to a cell using Hyperlink and Match on two separate rows

    Thanks AskMeAboutExcel, this is exactly what I was looking for. I just wanted to search both rows for the value but you worded much better than I did. The formula worked perfectly.
    Thanks again!

+ 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. Replies: 1
    Last Post: 11-24-2020, 11:05 PM
  2. [SOLVED] Hyperlink Jump to Location
    By loverfellow in forum Excel General
    Replies: 2
    Last Post: 11-26-2015, 02:20 AM
  3. Separate and align rows from two separate sheets based on a cell value.
    By Sonny Crockett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2015, 09:15 PM
  4. [SOLVED] Macro Button to find match and jump page to that cell
    By JohnDoh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2015, 10:18 AM
  5. Replies: 5
    Last Post: 09-16-2014, 12:17 PM
  6. Help! Need to move rows to separate worksheet if cell values match a value in range
    By nzamparo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2011, 12:20 AM
  7. How to make Hyperlink jump accordingly
    By crapit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2005, 12:05 AM

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