Golf League Differential Two Way Lookup In Excel 2368

У вашего броузера проблема в совместимости с HTML5

Sean is calculating scores for a golf league. The Differential is Score minus Rating times 113 divided by the Slope. Given a course name and set of pins, he needs to lookup into a table to get the rating and slope.
Download the workbook from: https://1drv.ms/x/s!As7G72Sl487JlgDFiXEYpMDi9TTU?e=nh9kKK
This video shows three easy ways to do the two way lookup:
FILTER function in Excel or Google Sheets
XLOOKUP function in Excel
Power Query in Excel (the best and easiest way)

Table of Contents
(0:00) Intro to video
(0:40) Calculating a Differential
(1:07) Solving with a FILTER function in Excel
(4:30) Solving with a two-key XLOOKUP
(5:20) Solving with a merge in Power Query
(7:48) Wrap-up