Login to online classes

VLOOKUP Formula Cheat-sheet – FREE Download

  • Last updated on November 19, 2010
Picture of Chandoo

Chandoo

Share

Facebook
Twitter
LinkedIn

FREE VLOOKUP Formula Cheat-sheet - Download todayWe have talked a lot about VLOOKUP and other lookup formulas recently during VLOOKUP Week.

In this post I am giving away a free VLOOKUP formula cheat-sheet for our readers. This cheat-sheet is prepared by Cheater John specifically for our readers. I hope you enjoy the one page help on VLOOKUP.

Click here to download VLOOKUP Cheat-sheet. [mirror]

More resources on VLOOKUP & Other Lookup Formulas:

Thanks Cheater John

Thanks to Ates, the person behind Cheater John for preparing this beautiful VLOOKUP cheat sheet and sharing it with us. Visit his site if you are looking for more such cheat sheets.

If you enjoyed this cheat-sheet, please take a minute to say thanks to Cheater John.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

advanced-excel-dashboards-course-chandoo
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst

FREE Goodies for you...

Excel formula list - 100+ examples and howto guide for you
100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks
13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Related Tips

3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”

  1. Malani says:
    April 14, 2021 at 10:32 am

    Hi Chandoo,
    I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
    Here is the Scenario;
    The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
    How can I create such a tracker?

    Reply
  2. Carl says:
    April 21, 2022 at 11:53 am

    Hi Chandoo,
    I am a member of your excel school.
    I was trying to create SOP Tracker I follow all your steps but I keep this error below.

    The list source must be a delimited list, or a reference to a single row or cell.

    I try looking on YouTube for answer but no luck.

    can you help on this?

    thanks
    Carl.

    Reply
  3. Rakesh says:
    August 15, 2022 at 3:33 pm

    Dear Mr. Chando,

    Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?

    I also watching your videos in YouTube. i hope you can help me on this situation.

    Reply

Leave a Reply