Both way lookups

In this exercise, you will complete the missing table cells using lookups.

Looking up values is an everyday chore of any Excel user! You've already mastered VLOOKUP() and HLOOKUP(), but, as you well remember, these aren't infallible functions. Thankfully, as of Excel 2021 we have a new kid on the block, XLOOKUP(). Are you ready to apply it in practice while analyzing a large shop sales?

For your convenience, we're leaving you with the syntax of this useful function: