Card Game Spreadsheet

[BlackObsidian]

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 card
with columns to reflect each of the attributes above. A=Name, B=ATK et
etc

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

This in itself isn't a problem as I know I can type a list of card
directly above the cell to be typed into and Hide those Cells so tha
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

 

[jeff]

Hi,

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

jeff

 

[JulieD]

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