Card Game Spreadsheet

B

BlackObsidian

Thanks for all your help Julie and Jeff, much appreciated!

I'm using the following as a testbed before I start entering all th
card data into the spreadsheet.

The card details are defined in B1:G1 as follows:-

(Card Name | Level | Element | ATK | DEF | Details)
Levia | 6 | Water | 3000 | 2000 | A huge red Dragon

The Bracketed Attributes aren't on the actual spreadsheet.

I'm using the following in C6 to Vlookup card details from th
user-entered data entered into B6.

=VLOOKUP(B6,Sheet1!B1:G1,2,0)

However it's only returning the "Level" statistic of "6"

How would I return all other statistics for the card please?

Many thanks, much appreciated! :
 
Top