I am currently trying to figure out how to do a vlookup (if even possible) to pull results from two different tables.

In my example right now I have a lookup table that will be used to reference
Apple Fruit
Orange Fruit
Grapes Fruit
Bread Other
Lettuce Vegetable
Eggs Other
Spinach Vegetable

But given I have 2 other tables that I must use to lookup the values, I want the result to come back as "fruit" even if the other table has an item that would return a value as "other." If it is possible, I would like it to come back in a hierarchy starting with fruit, then vegetable. I want the "fruit" value to override the result from the other table.

The end result I am trying to get to is:

Table 1(lookup value) Table 2(lookup value) End Result
Eggs Orange Fruit
Bread Spinach Vegetable
Eggs Apple Fruit
Spinach Apple Fruit

Any ideas on how I will be able to do that?