Hi, anyone know the formula for below situation ?

1.I got two excel file = 1.xls & 2.xls
2.both of the file in column A have the customer name,but 2.xls got more few
customers name tat 1..xls dont have.
3.both of the file in column B have the price.

Now I wish to filter the 2.xls column A and leave those name which exactly
same with 1.xls column A,n i wish to get the price from 2.xls's(column B)
after filter's name, and let the answer shown in 1.xls coloumn c for
comparison.

Anybody can help ?

Thanks !