Get startedGet started for free

Lookups galore!

By now you are familiar with many lookup and reference methods!

In this exercise, it's your mission to lookup the two missing values in the bottom table, based on the top reference table.

A table with product reference data such as Stock Code, Description and Average Unit Price

Which TWO below functions would do the job?

This exercise is part of the course

Advanced Excel Functions

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise