+ Reply to Thread
Results 1 to 3 of 3

Meal Plan - hyperlink vlookup result to worksheet in same workbook

  1. #1
    Registered User
    Join Date
    12-10-2018
    Location
    Canada
    MS-Off Ver
    Microsoft 365
    Posts
    54

    Meal Plan - hyperlink vlookup result to worksheet in same workbook

    HI,

    Just wondering if it is possible to hyperlink to another worksheet from a vlookup result (without VBA).

    So I'm making a meal plan for our family and have used vlookup with a data validation list to select meals for the family.

    example will be using Monday Breakfast meal (B2)

    So, drop down the arrow for Monday (B2) for each meal or side. then it produces a vlookup result based off that in cells C2 and D2.

    So using cell B2, we drop down the "list" and select egg biscuit. C2 populates the meal name, then D2 populates the ingredients required for that meal.

    What I'm hoping to do is based off the Main (cell C2), is to create a hyperlink to the recipe page (Egg Biscuit Recipe) unless using B2 makes more sense to hyperlink.

    Any help is appreciated!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    850

    Re: Meal Plan - hyperlink vlookup result to worksheet in same workbook

    Hi there,

    On the MEAL sheet in cell D2 (then pull down) try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  3. #3
    Registered User
    Join Date
    12-10-2018
    Location
    Canada
    MS-Off Ver
    Microsoft 365
    Posts
    54

    Re: Meal Plan - hyperlink vlookup result to worksheet in same workbook

    That works!

    Quick question, is it possible to link to another tab versus going to the breakfast page for the ingredients?

    For example if you click the hyperlink it brings you to the egg biscuit recipe tab? Or for dinner the Green Enchilada Soup Tab (when selected)

    Edit: Never never mind I don't have it.
    Last edited by Cleetus09; 01-18-2021 at 10:53 AM.

+ 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. Index Match Hyperlink result from external workbook not loading
    By JDFexcel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-13-2019, 09:45 AM
  2. Replies: 1
    Last Post: 06-29-2017, 02:11 AM
  3. Meal plan to return Fat, Protein, etc.
    By geoponic in forum Excel General
    Replies: 4
    Last Post: 10-15-2016, 02:48 AM
  4. [SOLVED] hyperlink as result of vlookup function not working
    By Bart755 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-18-2016, 04:32 AM
  5. [SOLVED] Use VLookup result at hyperlink
    By keredu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 01:55 PM
  6. Help with calculations in a meal plan!
    By TASan in forum Excel General
    Replies: 7
    Last Post: 06-21-2012, 09:53 AM
  7. VLookup result not clickable hyperlink
    By CHoedeman in forum Excel General
    Replies: 5
    Last Post: 02-16-2011, 08:54 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