Card Game Spreadsheet

Hi all!

Suppose I have a real-life card game with 100 cards.

Each card has a Card Title, Attack, Defense, Element type and Level.
e.g.

The Warrior
ATK: 2000
DEF: 1000
Element: Water
Level: 6

I have designed a spreadsheet for people to design a deck of 20 cards
with columns to reflect each of the attributes above. A=Name, B=ATK etc
etc

Instead of a user having to go through each cell and fill out the
relevant information I want to enable the user to begin typing the name
of the card and excel should reach a certain amount of characters before
knowing what card it is and give the user the option to hit return to
auto-fill the cell.

This in itself isn't a problem as I know I can type a list of cards
directly above the cell to be typed into and Hide those Cells so that
when a user starts typing, it auto-fills that cell.

The problem occurs because I'd like to be able to fill in Column B, C,
D and E with the relevant information for the card name entered.

Any suggestions?

Thanks all!


--
BlackObsidian
------------------------------------------------------------------------
BlackObsidian's Profile: http://www.excelforum.com/member.php...o&userid=14843
View this thread: http://www.excelforum.com/showthread...hreadid=264706

Hi,

Yes, Use the Vlookup function which can look up the
characteristics based on the value in another column.

jeff


-----Original Message-----

Hi all!

Suppose I have a real-life card game with 100 cards.

Each card has a Card Title, Attack, Defense, Element
type and Level.
e.g.

The Warrior
ATK: 2000
DEF: 1000
Element: Water
Level: 6

I have designed a spreadsheet for people to design a
deck of 20 cards
with columns to reflect each of the attributes above.
A=Name, B=ATK etc
etc

Instead of a user having to go through each cell and
fill out the
relevant information I want to enable the user to begin
typing the name
of the card and excel should reach a certain amount of
characters before
knowing what card it is and give the user the option to
hit return to
auto-fill the cell.

This in itself isn't a problem as I know I can type a
list of cards
directly above the cell to be typed into and Hide those
Cells so that
when a user starts typing, it auto-fills that cell.

The problem occurs because I'd like to be able to fill
in Column B, C,
D and E with the relevant information for the card name
entered.

Any suggestions?

Thanks all!


--
BlackObsidian
---------------------------------------------------------
---------------
BlackObsidian's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=14843
View this thread:
http://www.excelforum.com/showthread...hreadid=264706

.

however the table_array would need to be in columns across the page
e.g.
A B C D E
Card Title Attack Defense Element type Level

or HLOOKUP can be used if it is down rows
Card Title
Attack
Defense
Element Type
Level

but then all the different cards titles etc need to be across columns from A
to IV

using VLOOKUP the formula would be similar to
=VLOOKUP(lookup_value, table_array, col_index_num, match_type)
=VLOOKUP(A1,Sheet2!A2:E102,2,0)

where A1 is the card that your players have chosen, sheet2!A2:E102 is the
list of cards as outlined above, 2 is the column number of the piece of data
you want to return & 0 means you want to do an exact match. Remember the
1st parameter (lookup_value) must be the leftmost column in the table_array
(2nd parameter)

Hope this helps
Cheers
JulieD



"jeff" wrote in message
...
Hi,

Yes, Use the Vlookup function which can look up the
characteristics based on the value in another column.

jeff


-----Original Message-----

Hi all!

Suppose I have a real-life card game with 100 cards.

Each card has a Card Title, Attack, Defense, Element
type and Level.
e.g.

The Warrior
ATK: 2000
DEF: 1000
Element: Water
Level: 6

I have designed a spreadsheet for people to design a
deck of 20 cards
with columns to reflect each of the attributes above.
A=Name, B=ATK etc
etc

Instead of a user having to go through each cell and
fill out the
relevant information I want to enable the user to begin
typing the name
of the card and excel should reach a certain amount of
characters before
knowing what card it is and give the user the option to
hit return to
auto-fill the cell.

This in itself isn't a problem as I know I can type a
list of cards
directly above the cell to be typed into and Hide those
Cells so that
when a user starts typing, it auto-fills that cell.

The problem occurs because I'd like to be able to fill
in Column B, C,
D and E with the relevant information for the card name
entered.

Any suggestions?

Thanks all!


--
BlackObsidian
---------------------------------------------------------
---------------
BlackObsidian's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=14843
View this thread:
http://www.excelforum.com/showthread...hreadid=264706

.