0 of 46 lessons complete.
Module 7: Lookups · Lesson 37 of 46
VLOOKUP
Pull values from a table by looking up a key.
Step 1 of 20%
VLOOKUP finds a value in the first column of a table and returns a value from another column: =VLOOKUP(what to find, table, column number, FALSE). In F2, look up the density of the material in E2.
Target: F2
A1
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Material | Density (kg/m³) | Yield Strength (MPa) | Look up | Density | Yield Strength | ||
| 2 | Steel | 7850 | 250 | Titanium | ||||
| 3 | Aluminum | 2700 | 95 | |||||
| 4 | Copper | 8960 | 70 | |||||
| 5 | Titanium | 4500 | 880 | |||||
| 6 | Brass | 8500 | 200 | |||||
| 7 | ||||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $