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.