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