Question 1 of 5
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Product | Key | Sales |
| 2 | North | Apple | 120 | |
| 3 | North | Banana | 90 | |
| 4 | South | Apple | 150 | |
| 5 | South | Banana | 60 | |
| 6 | East | Apple | 200 |
VLOOKUP with Multiple Criteria - Free Excel Practice Online
This free, interactive exercise teaches you VLOOKUP with Multiple Criteria in Excel through 5 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising VLOOKUP with Multiple Criteria this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this VLOOKUP with Multiple Criteria lesson
- VLOOKUP can only search one column, so to match on two things you build a key column first. Join the region and the product by typing =A2&B2 in C2. - The & operator joins the two criteria into a single value, NorthApple. Fill this down the column and you have something VLOOKUP can search.
- The key column is filled in now. Find the sales for South + Banana by typing =VLOOKUP("SouthBanana", C2:D6, 2, FALSE) in F5. - The search range starts at C2 because VLOOKUP always searches the first column of the range you give it. Sales is the 2nd column of C2:D6, so the answer is 60.
- Build the key from cells rather than typing it. F2 holds the region and G2 the product. Type =VLOOKUP(F2&G2, C2:D6, 2, FALSE) in F5. - F2&G2 builds SouthApple on the fly, so changing either cell changes the answer. South + Apple is 150.
- Change the criteria and the same formula follows. F2 and G2 now hold East and Apple. Type =VLOOKUP(F2&G2, C2:D6, 2, FALSE) in F5 again. - Nothing about the formula changed, only the cells it reads. East + Apple is 200. This is why building the key from cells beats typing it into the formula.
- When the answer is a number you can skip the key column entirely. SUMIFS takes as many criteria as you like. Type =SUMIFS(D2:D6, A2:A6, "North", B2:B6, "Apple") in F6. - SUMIFS matches on both columns directly, with no helper column to build or maintain. North + Apple is 120. Use the key column when you need to return text, and SUMIFS when you need a number.
VLOOKUP with Multiple Criteria practice - FAQ
How do I practice VLOOKUP with Multiple Criteria in Excel?
Open this free LogicExcel exercise and work through 5 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the VLOOKUP with Multiple Criteria exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this VLOOKUP with Multiple Criteria lesson?
This lesson covers VLOOKUP with Multiple Criteria as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.