Exact match VLOOKUP.
Product IDs are in F2:F20 with prices in G2:G20. In B2 look up the ID in A2 with VLOOKUP, column 2, exact match FALSE.
Ready to try it?
Create a free account and try "Lookup a Price" free for 7 days, no card required. Earn 150 XP and track your internship progress.
Already have an account? Sign in