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
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