Look up a price with INDEX and MATCH

Premium

In F2, return the Price of the product in E2. Use MATCH to find its row in A2:A7 and INDEX to pick that row from C2:C7.

F2
ABCDEFG
1Product Unit Price Product Price
2Apples kg 22 Figs
3Bananas kg 18
4Cherries box 45
5Dates box 38
6Figs piece 6
7Grapes kg 30
8

Premium lesson

Unlock INDEX and MATCH and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:XLOOKUPIFERROR

It comes up in this mock test: Excel test for job interviews

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?