Results 1 to 29 of 29

How to use VLOOKUP (via Formula How-Tool)

Threaded View

  1. #1
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    How to use VLOOKUP (via Formula How-Tool)

    I'm really excited about sharing this! This tool guides you on how to use formula (the name, Formula How-Tool, was suggested by my dear wife. how-to sounds like how-tool.)

    So one fine day, I was just thinking about how I can help people understand how to use formulas and I thought "hey, maybe if Excel can do some animations, that would help". I googled on how to do that and that's where I learned how to do it in wiseowl's blog. I also googled to see if there are existing tools like mine and i didn't find any.

    I am pretty weak in VBA, so it took me a couple of months to turn my concept into reality. Also gotten help from a fellow excel forum member, karedog, on how to transfer variables across modules to make this work. I hope this tool really helps you to understand how to use the formulas and feel free to let me know on anything I can improve on. Read the instructions carefully & enjoy!
    Attached Files Attached Files
    Last edited by Fotis1991; 04-18-2016 at 06:00 AM.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help to find universal extended VLOOKUP tool
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2016, 03:11 AM
  2. Vlookup tool
    By crescendo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-06-2014, 03:52 PM
  3. [SOLVED] Formula evaluation tool
    By Richard N in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2013, 04:25 PM
  4. Is VLOOKUP the right tool?
    By bwg80 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2008, 12:37 PM
  5. Is VLOOKUP/HLOOKUP The Right Tool
    By ajax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2007, 07:59 PM
  6. [SOLVED] I am missing view tool bar from tool menu.
    By excel in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2005, 03:05 PM
  7. Formula Tool
    By ceemo in forum Excel General
    Replies: 9
    Last Post: 05-01-2005, 04:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1