Display Value from matching from columns in two separate tables.

[expeo]

What would be the formula to display the unit "Three" in Column H if given the unit "Two" and "Four"?

It would have to match and validate in two separate tables; Table 1 (Column A:B) and Table 2 (Column C:E).
For example, if given unit Two=10, it should first validate to match Table 1 where it gives the possible unit(s) of "Three".
Then it should validate with Table 2 (using 10 and possible unit Three) and finally the corresponding unit "Four" from Table 2 should display in Column J.

Seems a little confusing with two tables, any method or formula would be appreciated. Maybe I can try consolidating the two tables into one and/or use some like of Index or Vlookup with Sumproduct? I cannot seem to formulate any of this.

Table 1 Table 2 Given

[TABLE="width: 0"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Two
[/TD]
[TD]Three
[/TD]
[TD][/TD]
[TD]Two
[/TD]
[TD]Three
[/TD]
[TD]Four
[/TD]
[TD][/TD]
[TD]Two
[/TD]
[TD]Four
[/TD]
[TD]Three
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]110
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]110
[/TD]
[TD]9000
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]9000
[/TD]
[TD]110
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]10
[/TD]
[TD]111
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]122
[/TD]
[TD]9000
[/TD]
[TD][/TD]
[TD]Given
[/TD]
[TD]Given
[/TD]
[TD]Displays
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]11
[/TD]
[TD]110
[/TD]
[TD][/TD]
[TD]11
[/TD]
[TD]110
[/TD]
[TD]9101
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]12
[/TD]
[TD]111
[/TD]
[TD][/TD]
[TD]12
[/TD]
[TD]130
[/TD]
[TD]9202
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 0"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[expeo]

Correction: What would be the formula to display the unit "Three" in Column J if given the unit "Two" and "Four"?

Sorry.