VLookup + Hyperlinks

I am a recent diagnosed diabetic and am developing a "database" to go shopping. The "Pick It" tab correctly updates ingredient list from whatever selection I make in cell A7. It pulls from the "DATABASE" tab.

What I am trying to get to work is, having the hyperlink under the word Recipe, which is from column 2 of the DATABASE tab, be duplicated/copied from the DATABASE TAB and that will take me to the tab/sheet that has the picture of the actual recipe. I know once I'm on the recipe tab I can place a simple hyperlink to get back to the "Pick it" tab.

You can ignore the paste it tab, That is where I'm going to cntl-c and cntl-v the ingredients to "build" my shopping list.

Thank you.

ETA: There is a formula in Cell M7 on the "Pick it" tab, that I think is close, but no cigar. lol

V/R Joe

This may not be what you are looking for but the one way I know to do it is to use a second cell as a reference. So I put the reference formula to "go" in cell L7 of the PICK_IT tab (and I changed the name as the formula will not jump to a tab name that contains a space). I also changed your recipe names to match the tab names you have. Finally I put in a go back function in each of the OBSF and PMQ tabs so you can jump between the pick it tab and the recipe tabs. See attached.

I saw this and said, "Hey, I bet there are a lot of people out there who would like a spreadsheet like this." So I sort of took it and ran with it. It's more than you are asking for, but you might find it handy.

In fact, I would like to have your input on other features that you may want in this application.

One thing might be to develop a shopping list. You select the meals and it will consolidate the ingredients. This would require consistent units of measurement for like items. For example Salt would always be expressed in teaspoons. Otherwise you would wind up with 12 teaspoons of salt and 3 tablespoons of salt. Of course, salt is a poor example since you buy it by the pound.

Another thing might be a weekly meal planner. I have no idea what shape this may take and I'd take any suggestions.

Attached is the application with your two examples plus one that I added so I could document the steps used to add a new recipe.

Trying to help also.

Diabetes recipes from BBC site, half dynamic link, in near future might be full dynamic because of new Excel feature.

Sheets 'Food of the day', 'Dishes', 'Ingredient', 'Method'. Recipes with picture.

Glad that I was able to help, AND thank you for the rep!
As far as the "#" before the cell address I was trying to research it but was unsuccessful. I know that without it, it appears like a hyperlink but will not function.
Maybe someone else on here knows the reason for it? =HYPERLINK("#"&M6&"!a2","Go")