How to compare 2 excel file data by VBA?

Dear Experts,

here is just a example.
http://us.a2.yahoofs.com/users/4397d...Ij.lDBCiTjmHKQ http://us.a2.yahoofs.com/users/4397d...Ij.lDBZdlNjpZ0
testing1.xls A column is the type of name
testing1.xls B column is the name
testing2.xls B column is the name need to SEARCH

SEARCH function:
input: testing2.xls B column
output: search the name of testing1.xls and output the corresponding type

testing2.xls C column is the output of the search

How can i have the output?
by newbie

I think that the function your looking for is "VLOOKUP"

Excel should walk you through how to use it, if not post again and I'll explain it.