Excel formula help

[g3lo18]

Hi,

I am working with excel as a hobby and creating a lottery checker for fun to gain some experience with excel and its formula's.

I am trying to figure out how to do the following.

I have two tables set up.

In one you have 7 numbers you enter and in another table you have 7 numbers that are drawn. I am trying to figure out how tell excel to compare the 7 numbers drawn to the numbers you entered. If all 7 numbers match, than I want excel to produce a 1. If not I want excel to produce a 0.

Any help is greatly appreciated. Each number is in its own cell so I have 7 cells across.

 

[g3lo18]

Im working with 2003. And I didnt try the above formulas. I figured it out with the one I posted above.

 

[g3lo18]

Another question I have is, what formula am I able to use if I have 22 conditions to check?

For instance, I have 7 binaries.

0000000 or 1111111 or 0101011 etc.

I have 22 possibilities and in one cell I would like to have a formula that analyzes the set of 7 binaries and goes through 22 possibilities and if a certain possibility is matched it inserts a true value if not it inserts nothing.

I know Nested IF statements but I think they are limited to 7 outcomes.

 

[Aladin Akyurek]

Im working with 2003. And I didnt try the above formulas. I figured it out with the one I posted above.

Did you also see #20?

 

[Aladin Akyurek]

Another question I have is, what formula am I able to use if I have 22 conditions to check?

For instance, I have 7 binaries.

0000000 or 1111111 or 0101011 etc.

I have 22 possibilities and in one cell I would like to have a formula that analyzes the set of 7 binaries and goes through 22 possibilities and if a certain possibility is matched it inserts a true value if not it inserts nothing.

I know Nested IF statements but I think they are limited to 7 outcomes.

Would you give an example of a match and another of a no match?

 

[g3lo18]

Ill try #20, Thank you!

For example:
1111111 - match - $200
0111111 - match - $100
0011111 - match - $50

etc

 

[Aladin Akyurek]

Ill try #20, Thank you!

For example:
1111111 - match - $200
0111111 - match - $100
0011111 - match - $50

etc

Create a 2-column table which associates digit sequences with dollar values. You can then use:

=VLOOKUP(A2,Table,2,0)

where a digit sequence is located in A2.

 

[g3lo18]

Thank you Aladin for the Blank formula. It worked.

I have attached the completed excel. I think it works well. What you guys think?

Also, is there a way to save the excel worksheet as a program? For instance, so I can post it online or something?

https://www.dropbox.com/s/xz0a0w5cz8t0s5k/Lotto MAX Checker.xls

 

[bschwartz]

You can try uploading it to Google Docs and converting it to a Google Doc file.