← All exercises

VLOOKUP exact match — Catalog

Exact VLOOKUP — Catalog

Look up a product's name, category or price from its reference in a 12-item catalog using VLOOKUP in exact-match mode — 3 guided steps.

=VLOOKUP( value , range , col_num , FALSE )

1 / 3

Find the value in column 2 for P003

=VLOOKUP( value , range , col_num , FALSE )

2 / 3

Find the value in column 3 for P006

=VLOOKUP( value , range , col_num , FALSE )

3 / 3

Find the value in column 4 for P004

Your score is

0%