Both way lookups

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

You can complete this exercise on DataCamp using in-browser Excel in the virtual lab, or locally on your machine if you have Excel installed. For working locally, you can download all the course datasets from here.

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:

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])