How to cross reference a cell with different names?

[Exselinoce]

Hi All!

I am a first time poster long time stalker. I am trying to do some type of Vlookup between two pivot tables. Both pivot tables have the same data but some of the names are different because it derived from a different source but they have the same data I want. For Example:

First Table	Data
Apples	5
Oranges	7

<tbody>
</tbody>

Second Pivot Table	Data 1	Data2	Data3
MangoApple	Sweet	Summer	5
RavishingOrange	Juicy	Spring	7

<tbody>
</tbody>

I want to do a vlookup or similar to find these and come up with same data end result. Also, I know there is a short code for writing formulas for concatenate (&), is there one for OR. Like if I were to continue with V-Lookup could it be Vlookup(a1&b1,c1:c2&b1:b2,3,false) but for OR

Thanks