0 of 46 lessons complete.
Module 7: Lookups · Lesson 38 of 46
XLOOKUP
Use XLOOKUP, the modern replacement for VLOOKUP.
Step 1 of 20%
XLOOKUP is simpler: =XLOOKUP(what to find, where to look, what to return). In G2, look up copper's yield strength.
Target: G2
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 | Copper | ||||
| 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 $