How to compare 2 excel file data by VBA?

[kevinkwantc]

Dear Experts,

here is just a example.

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

[mwyatt]

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.