What is the best way to join / join two tables by column cells in Excel?

Question

I found this great buy-in add-on that seems to do what I need, but I'd rather have a code that opens to use as I wish. Although the GUI is nice, it is not required.

In an attempt to make the question more understandable, I add several two “input” tables in a tab delimited form and a summary output table:

SAMPLE_INPUT_TABLE_01

horse<tab>age<tab>body
a<tab>1<tab>A
b<tab>2<tab>B
b<tab>3<tab>C
c<tab>4<tab>D
e<tab>5<tab>E
f<tab>6<tab>F

SAMPLE_INPUT_TABLE_02

rider<tab>horse<tab>finish<tab>date
xxx<tab>a<tab>yy<tab>zz
xxx<tab>b<tab>yy<tab>zz
xxx<tab>b<tab>yy<tab>zz
xxx<tab>c<tab>yy<tab>zz
xxx<tab>e<tab>yy<tab>zz
xxx<tab>f<tab>yy<tab>zz

SAMPLE_OUTPUT_TABLE_03

rider<tab>horse<tab>finish<tab>date<tab>age<tab>body
xxx<tab>a<tab>yy<tab>zz<tab>1<tab>A
xxx<tab>b<tab>yy<tab>zz<tab>3<tab>C
xxx<tab>b<tab>yy<tab>zz<tab>3<tab>C
xxx<tab>c<tab>yy<tab>zz<tab>4<tab>D
xxx<tab>e<tab>yy<tab>zz<tab>5<tab>E
xxx<tab>f<tab>yy<tab>zz<tab>6<tab>F

If that matters, I'm using Office 2010 on Windows 7.

Answer 1

I think this emulates an example in your link:

Formulas

I2 ( ):

=VLOOKUP(F2,$A$2:$C$7,2)

J2 ( :

=VLOOKUP(F2,$A$2:$C$7,3)

Answer 2

, vlookup . , , , . , , .