Recently I’ve had a few people ask my “favorite” this and my “favorite” that and it got me thinking. I have a few random favorites that would be fun to share! Excel Function – VLOOKUP I can’t tell you how many times I have been confronted with needing data in one spreadsheet to have a field or 6 from another. And they are never 10 records – always several thousand. That’s where VLOOKUP comes in. You tell it to match a field from one sheet to another, and when it finds a match, bring over additional data. AWESOME! So how do you use it? Here’s an example: A client exported a list of customers from their contact management system, added a bunch of information and then realized they forgot the company name. Email is a unique identifier so we were able to run a VLOOKUP […] Continue reading