Forum Discussion

ExcelTL's avatar
ExcelTL
Copper Contributor
Jul 30, 2020
Solved

How old is VLOOKUP?

To this day, I still get requests for help using VLOOKUP and see new blog posts teaching basic usage. Given the improvement with XLOOKUP, I'm wondering just how long VLOOKUP has been around. Excel 95? Excel 4.0? I just don't know and haven't found function reference lists that old. Would like to use that as a story point for change management.

  • ExcelTL It's actually a little older, that's when it arrived in Excel.

     

    I believe VLOOKUP first appeared in Lotus 1-2-3 which predated Excel. According to Wikipedia, Lotus 1-2-3 launched in January 1983, so VLOOKUP appeared sometime around then. VLOOKUP was actually the successor to the original lookup style function, LOOKUP(), which first appeared in VisiCalc in 1979. LOOKUP was created to help with Bob Frankston's tax return. You can read about it here.

     

    LOOKUP and VLOOKUP have an amazing history, dating all the way back to the very early days of spreadsheeting. Hats off to the early spreadsheet pioneers. 

5 Replies

  • ExcelTL's avatar
    ExcelTL
    Copper Contributor

    Ha! Found the answer immediately after posting in JoeMcDaid's post on Announcing XLOOKUP.

     

    According to Joe, "VLOOKUP has been with Excel from the beginning; it was included in Excel 1 for Macintosh released in 1985. For 35 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE)."

     

    35 years for Mac! 33 years for Windows!

    • JoeMcDaid's avatar
      JoeMcDaid
      Icon for Microsoft rankMicrosoft

      ExcelTL It's actually a little older, that's when it arrived in Excel.

       

      I believe VLOOKUP first appeared in Lotus 1-2-3 which predated Excel. According to Wikipedia, Lotus 1-2-3 launched in January 1983, so VLOOKUP appeared sometime around then. VLOOKUP was actually the successor to the original lookup style function, LOOKUP(), which first appeared in VisiCalc in 1979. LOOKUP was created to help with Bob Frankston's tax return. You can read about it here.

       

      LOOKUP and VLOOKUP have an amazing history, dating all the way back to the very early days of spreadsheeting. Hats off to the early spreadsheet pioneers. 

      • mathetes's avatar
        mathetes
        Silver Contributor

        JoeMcDaid 

         

        I can testify to personal experience using VLOOKUP with Lotus 1-2-3 in spreadsheets in the time period of 1983-5. I was director of HR for a division of a major (Fortune 50) corp......and one of the first computer geeks to get turned on to how easily one could do all kinds of fancy things for modeling, say, compensation plans. I can recall nesting an HLOOKUP within a VLOOKUP (or maybe it was the other way around), doing some of the things that INDEX and MATCH can do........

         

        I can also recall taking the user manuals home on the train, reading about every function, going "Ah ha, that's an easier way to _________" and thinking I can't wait to get back to the office tomorrow to try it out on that big shared-around-the-office PC.

         

        How things have changed.

Resources