Some people are aware of the VLOOKUP function, but not as many are familiar with MATCH and OFFSET. If you use VLOOKUP, you should learn about the other two as they may come in handy when the other doesn't quite fit your need.
Instead of recreating the explanation, here is a simple and easy to understand explanation from Chandoo, MVP (@r1c1).
No comments:
Post a Comment