Microsoft Excel — Hard
Key points
- Search direction differs among the three functions
- Return values are dependent on the function's orientation
- LOOKUP requires sorted data for its vector form
- VLOOKUP and HLOOKUP have distinct use cases
Ready to go further?
Related questions