Four arguments, one job: find this thing in that list and bring back a column.
Module 1 taught you to build one tidy list and make it behave. Real office work is rarely one list. It's two lists that need each other.
Picture this. Rahul from Module 1 has turned his stationery habit into a small shop. He now has:
An Orders list — who bought what, and how many.
A Price list — every product and its price, kept on its own part of the sheet where it belongs (raw data stays raw, as Module 1 taught).
The orders list has the product name but not the price. To bill anyone, Rahul needs Excel to look up each product in the price list and bring back its price. Doing that by eye for 8 rows is annoying. For 8,000 rows it's a full day. For Excel it's one formula: VLOOKUP.
The setup
Put the price list in columns F to H:
F
G
H
1
Product
Category
Price
2
Notebook
Paper
60
3
Pen
Writing
15
4
Bag
Travel
850
🔒
Keep reading with Pro
You are reading the free preview. Module 1 of every course is free forever — Pro unlocks the rest of this lesson, every other module of every course, removes ads, and adds workbooks and certificates.