RSS

Tag Archives: formula

#949: Use VLOOKUP

Some facts about my dark spreadsheet past:

  1. I had learned to use VLOOKUP before.
  2. I had vowed to use VLOOKUP before.
  3. Whenever I had an opportunity to use VLOOKUP, I forgot how and didn’t want to spend the time or energy re-learning, so I just used a different formula or function.

But yesterday, I had an Excel task I couldn’t see an alternative solution for that wouldn’t require an hour of extra work, so I took the 5 minutes to re-learn how to use VLOOKUP yet again, and then I actually used it.

And it worked.

Read the rest of this entry »

 
Leave a comment

Posted by on April 26, 2017 in Computers

 

Tags: , , , , ,