VLOOKUP practice

VLOOKUP searches the first column of a range and returns a value from another column in the same row. Below are the 5 Excel exercises on Formuladrill that use it, each checked instantly in your browser.

Syntax

VLOOKUP(search_key, range, index, [is_sorted])

What people get wrong

Set the last argument to FALSE for an exact match; the default approximate match silently returns the wrong row on unsorted data.

Excel exercises that use VLOOKUP

• Find the priceLevel 3Pro
• Tax bracket lookupLevel 3Pro
• Price list into an orderLevel 3Pro
• Lookups that fail on stray spacesLevel 6Pro
• The wrong price columnLevel 7Pro

Often used together with: TRIM