Using VLOOKUP in Excel

Reply #7

capett02 — Mon, 09 Dec 2013 02:32:09 GMT

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

Reply #6

capett02 — Mon, 09 Dec 2013 02:20:18 GMT

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

Reply #5

winsumloosesum — Mon, 09 Dec 2013 02:06:39 GMT

Not sure if you need Lookup

I used the Auto Filter by column

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

Reply #4

LottoBoner — Mon, 09 Dec 2013 01:07:54 GMT

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.

Reply #3

capett02 — Sat, 07 Dec 2013 01:03:56 GMT

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.

Reply #2

SergeM — Sat, 07 Dec 2013 00:58:36 GMT

http://msdn.microsoft.com/en-us/library/office/dd797422%28v=office.12%29.aspx

Download the sample file and try it!

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

Reply #1

phileight — Sat, 07 Dec 2013 00:57:49 GMT

go to resourses and search for thread 247333

Using VLOOKUP in Excel

capett02 — Sat, 07 Dec 2013 00:35:55 GMT

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.