Vlookup results from 2 tables

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?

For the purposes of this example, let's assume that the top table in your inquiry is in cells A1:B7 and that the second table is in A9:C12. In cell C9, enter the following formula and drag down the column:

=IF(OR(VLOOKUP(A9,$A$1:$B$7,2,FALSE)="Fruit",VLOOKUP(B9,$A$1:$B$7,2,FALSE)="Fruit"),"Fruit",IF(OR(VLOOKUP(A9,$A$1:$B$7,2,FALSE)="Vegetable",VLOOKUP(B9,$A$1:$B$7,2,FALSE)="Vegetable"),"Vegetable","Other"))