use VLOOKUP without mentioning table

Hallo all,

Im having some difficuliets with the VLOOKUP function. I would like to type the name of the product and have the price show up next to it.

First of all I made a list and gave each section its own table. For example Tomato has the table: Veggies & Eggs has the table: Diary.

Here I use: =VLOOKUP(Eggs,Diary,FALSE)*Amount

This works fine, but I would like to do it without manually typing the table name into the formula

I also tried to take the table name out of the formula by putting it next to it. This also didnt work, I got the error #N/A.

How can I make this so the formula searches in every table for the right word, instead of having to put the table name in the formula manually each in time?

Thank you