🧮

Data Analysis Advanced

Index Match Lookup

⏱ 6 min ⭐ 200 XP 🔁 3 attempts allowed

What you'll do

Flexible lookup.

Scenario

Product IDs are in F2:F20 and prices in G2:G20. In B2 use INDEX(G2:G20, MATCH(A2, F2:F20, 0)).

Ready to try it?

Create a free account and try "Index Match Lookup" free for 7 days, no card required. Earn 200 XP and track your internship progress.

Already have an account? Sign in