'Is there ever a case when lookup is preferred to index-match?
It seems that index-match can do almost everything that lookup can do. The only case I can think of for using lookup is when you want to find the last cell that meets a condition
e.g. last nonblank cell
=lookup(2, 1 / (lookup vector <> ""), lookup_vector)
Are there any other situations when lookup would be preferred?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|