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:[TABLE="width: 500"]
<tbody>[TR]
[TD]First Table[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Second Pivot Table[/TD]
[TD]Data 1[/TD]
[TD]Data2[/TD]
[TD]Data3[/TD]
[/TR]
[TR]
[TD]MangoApple[/TD]
[TD]Sweet[/TD]
[TD]Summer[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]RavishingOrange[/TD]
[TD]Juicy[/TD]
[TD]Spring[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

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