I have excel macro work to be done.
1. Comparing two columns in 2 different files and insert values in the final file.
2. Comparing 2 columns and place in 3rd file according to above or below price ranges.
This work can be done using macros or automated software.