VLOOKUP

https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

An advanced excel function which will allow you to combine and cross-reference multiple excel files.  Useful for price overrides and eBay listing title exports.