2,384 views

Watch
- Search Videos
  
  Advanced search »
- Submit a New Video
Discuss
About
- Try clicking on the various channels to see videos posted to that channel - if you're into music you can click the Music channel to get more music sifts - go on and explore! Use the "hotness" when you have opened the channel link to get videos that have gotten a lot of votes, or use "newness" to have a look at the new sifts.
  When browsing sifts you like, have a look at the Related Posts list to see other related videos, click the tags under the video title to see more sifts tagged with the same tags or have a look at other sifts from the same user in the More Posts By list. If the sifted video is in a play list, have a look at the play list to see other interesting videos the Sift users have linked together.
  Enter the Sift Lounge to chat with online sifters about anything and everything, or read interesting posts in the Sift Talk forum.
  The Top New Videos list is always full of interesting, current videos. It is always recommended that you have a look through the Top New Videos, but also have a look at these:
  - Upcoming Unsifted Videos - active video submissions that neither are published to the front page nor archived to the submitter's personal queue
- Have you seen a really funny, surprising, scary, interesting, cute or in any other way extra good quality video?
  Post and share it here - VideoSift is the best video aggregator on the Web, where we share, discuss, promote, and interact with the best videos out there on the web. Post it here, and share it with the large community of video-interested users. And - you are guaranteed to find more very good videos here already!
  Mind you, we only share videos you discover that someone else has made; if you "self link," by posting a video you have made, have posted or have interests in, you risk the ban hammer - read the posting guidelines before posting. The sift is NOT for promoting your own videos - it is for sharing videos others have made.
  Submit a Video Now »
Login

How to use Excel's VLOOKUP function like a rockstar

submitted by Krupo

1 decade 5 years 10 months 3 weeks ago

If you use spreadsheets and lists of data, VLOOKUP will bail you out of dreadfully painful comparisons of related lists. I use this tool all the time for audit work, but there are many other wonderful uses, and this is probably the clearest and easiest to follow explanation regarding how it works, from a delightful British CA:
Emily Coltman. Her blog with the video is here.

And yes, they offer more videos as a service, but this lesson is absolutely free without any hard selling.

5 Comments

If you already knew about the loosely related "F4" trick, good for you - I was amazed by it though - love these little secrets.

dag

Comment hidden because you are ignoring dag.(show it anyway)

If I was indeed a rockstar, this is exactly how I would use VLOOKUP.

^ Agreed
I've seen Slash using that F4 trick.

Bono is really good at charts and pivot tables, but gets bogged down by long embedded formulae so he does a calculation in stages and just hides the columns.

Although the real master of the HLOOKUP is of course Bruce Springsteen who really knows how to work his functions. There's nothing quite like gathering round his cubicle and watching the boss at work.

If you press F4 enough times a ROCKING GUITAR SOLO appears according to CSI.

Hi, thanks for explanation! This tutorial also helped me much to understand how vlookup works:

http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup

Discuss...

🗨️ Emojis & HTML

Enable JavaScript to submit a comment.

This website uses cookies.

This website uses cookies to improve user experience. By using this website you consent to all cookies in accordance with our Privacy Policy.