VLOOKUP practice

VLOOKUP searches the first column of a range and returns a value from another column in the same row. Below are the 4 Google Sheets exercises on Sheetsdrill 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.

Google Sheets exercises that use VLOOKUP

• Find the priceLevel 3Pro
• Stock on handLevel 3Pro
• Zero instead of #N/ALevel 3Pro
• Shipping rate by weight bandLevel 3Pro

Often used together with: IFNA