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!
Bookmarks