#2 of the Top 5 Excel Functions: VLOOKUP

#2 of my Top 5 Excel Functions: VLOOKUP If VLOOKUP was a song, this would be it, I Like it Like That!   VLOOKUP can turn a 2-day ordeal into a 5-minute task.   Reasons to use VLOOKUP List of 400 addresses each needing to be assigned one of 9 Regions Master list of the...

Top 5 Excel Functions

Here’s the answer to a question about THE Excel Functions To Know. The request was for the top 10 but 10 is too many. After 3 or 4 functions, they get difficult to rank because they fall into areas of infrequent use or exclusive use. Things like INDIRECT, INDEX,...