How to compare compare common data in 2 seperate xl files

[pjm]

Hi,

I have 2 xl file as under:

File master.xls: This is master price list file listing available spares with company
File inquiry.xls: This is a new inquiry from a customer who requires limited spares

We would like to do the following:

1. Check for part no. (column B) from file inquiry.xls if it is found in file master.xls.
2. If found, to insert price found in file master.xls file (column c) in file inquiry.xls (column e)
3. For records not found, to mention NA

Request to kindly help.

Regards

Paresh