★0 XP
Question 1 of 10
Use VLOOKUP with approximate match (fourth argument is true) to classify an animal by weight. Use the cell reference E2.
Approximate match finds the largest value less than or equal to the lookup value. Note that this argument is true by default, so if you encounter a VLOOKUP without the fourth argument, it is using approximate match.
Approximate match finds the largest value less than or equal to the lookup value. Note that this argument is true by default, so if you encounter a VLOOKUP without the fourth argument, it is using approximate match.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | WEIGHT_LBS | SIZE_CLASS | EXAMPLE_ANIMAL | ||
| 2 | 0 | Tiny | Mouse | 420 | |
| 3 | 10 | Small | Rabbit | ||
| 4 | 100 | Medium | Dog | ||
| 5 | 500 | Large | Lion | ||
| 6 | 1,000 | Very Large | Horse | ||
| 7 | 5,000 | Huge | Elephant | ||
| 8 | 10,000 | Massive | Whale |
F2fx