### Excel Blackjack Game

by Published on 2010-11-15 08:57 PM     Number of Views: 31626

Just for fun, I decided that I would build a game in Excel, so here's my version of Blackjack.

Features:
The rules are pretty standard Blackjack rules... adjust your bet, then hit Deal. You get two cards, the dealer gets one up, one face down. You can hit or stay, and the hand will unfold for you.
...
• ### Recent Forum Posts

#### Conditionally filling a table based on non-unique information from another table

Just for completeness, this would be an AND lookup:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$A\$1:\$A\$13)/((\$C\$1:\$C\$13="Production")*(\$D\$1:\$D\$13="Forward")),ROWS(\$1:1))),"")...

AliGW Today, 03:35 PM

#### Conditionally filling a table based on non-unique information from another table

Yep, that did it! Thank you so much, it works amazing!...

Joecam Today, 03:21 PM

#### Conditionally filling a table based on non-unique information from another table

Maybe this?

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$A\$1:\$A\$13)/((\$C\$1:\$C\$13="Production")+(\$C\$1:\$C\$13="Something Else")),ROWS(\$1:1))),"")...

AliGW Today, 03:00 PM

#### Conditionally filling a table based on non-unique information from another table

That worked perfectly! Thank you!

What if column C had more options to choose from and I wanted to allow for multiple variables to be looked...

Joecam Today, 02:55 PM

#### Conditionally filling a table based on non-unique information from another table

And there he was, gone, with not one word of thanks for the solution offered. What happened to good manners and common courtesy, I wonder?...

AliGW Today, 02:32 PM