Welcome Guest
Log In | Register )
You last visited January 19, 2017, 11:54 am
All times shown are
Eastern Time (GMT-5:00)

Using VLOOKUP in Excel

Topic closed. 7 replies. Last post 3 years ago by capett02.

Page 1 of 1
51
PrintE-mailLink
capett02's avatar - nw femalewiz.jpg
Louisville, Ky
United States
Member #118930
November 11, 2011
289 Posts
Offline
Posted: December 6, 2013, 7:35 pm - IP Logged

I really hope someone can help me with the VLOOKUP function for a spreadsheet. I am attempting to enter the last pick three draw on my first worksheet and then have the function "LOOKUP" the number from the excel lottery bible sheet that I obtained off the LP thanks to Texas MadMan. I know how to do the other simple formulas I want to work with, but can't for the life of me understand the LOOKUP function. A huge THANK YOU in advance to anyone who knows how to make this work.

Bash

Diligence is the mother of good fortune - Benjamin Disraeli Type

    Avatar

    United States
    Member #41846
    June 23, 2006
    460 Posts
    Offline
    Posted: December 6, 2013, 7:57 pm - IP Logged

    I really hope someone can help me with the VLOOKUP function for a spreadsheet. I am attempting to enter the last pick three draw on my first worksheet and then have the function "LOOKUP" the number from the excel lottery bible sheet that I obtained off the LP thanks to Texas MadMan. I know how to do the other simple formulas I want to work with, but can't for the life of me understand the LOOKUP function. A huge THANK YOU in advance to anyone who knows how to make this work.

    Bash

    go to resourses and search for thread 247333

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: December 6, 2013, 7:58 pm - IP Logged
        capett02's avatar - nw femalewiz.jpg
        Louisville, Ky
        United States
        Member #118930
        November 11, 2011
        289 Posts
        Offline
        Posted: December 6, 2013, 8:03 pm - IP Logged

        Thank you phileight and Serge! I will definitely give it a shot. Extremely frustrating. I wanted to be done with this tonight so I can backtest it for Kentucky. Thanks again.

        Diligence is the mother of good fortune - Benjamin Disraeli Type


          United States
          Member #124493
          March 14, 2012
          7023 Posts
          Offline
          Posted: December 8, 2013, 8:07 pm - IP Logged

          I really hope someone can help me with the VLOOKUP function for a spreadsheet. I am attempting to enter the last pick three draw on my first worksheet and then have the function "LOOKUP" the number from the excel lottery bible sheet that I obtained off the LP thanks to Texas MadMan. I know how to do the other simple formulas I want to work with, but can't for the life of me understand the LOOKUP function. A huge THANK YOU in advance to anyone who knows how to make this work.

          Bash

          you can also check out mr excel on you tube,  thats where I learned how to do it, but i use it to look up skips.

          you can just search vlookup and a bunch of stuff will come up.

          Good luck.

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Offline
            Posted: December 8, 2013, 9:06 pm - IP Logged

            Not sure if you need Lookup

            I used the Auto Filter by column

            https://app.box.com/s/ogr0l05gjpiviofnurxn

              capett02's avatar - nw femalewiz.jpg
              Louisville, Ky
              United States
              Member #118930
              November 11, 2011
              289 Posts
              Offline
              Posted: December 8, 2013, 9:20 pm - IP Logged

              This is awesome. Thank you. I downloaded and can work with this. Now if I can find something that will show a positive gain after more than a couple of weeks backtesting, I will have it made. Every direction I attempt to go looks promising at first and then falls on its face. Thank you winsumloosesum!

              Diligence is the mother of good fortune - Benjamin Disraeli Type

                capett02's avatar - nw femalewiz.jpg
                Louisville, Ky
                United States
                Member #118930
                November 11, 2011
                289 Posts
                Offline
                Posted: December 8, 2013, 9:32 pm - IP Logged

                Thanks Lottoboner! Sorry I missed your post at first. Really appreciate the help folks!

                Diligence is the mother of good fortune - Benjamin Disraeli Type