Smart Lookup is often an ignored feature of Excel though present through Excel 2016. Very powerful and can increase your productivity to next level if used properly.
File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTlGQ9t04W4Pj1LC?e=RU7tQ9