Hi guys,
I just discovered Airtable and I am trying to use it as a database and a points calculator for a card-deck building game I am working on and now I am struggling with the scoring of ability combinations in a specific hand.
I have the following tables:
Characters - with all relevant character info
Abilities - all abilities with desc and each ability is linked to each character with that ability
Ability combos - a table with the scoring combos of abilities, for instance ability X and Y = 5 pts
Current deck - simulation of a hand with 7 cards
Cheat sheet - a table with all pairs of characters in “Current Deck”, i.e. Card 1 & Card 2, Card 1 and Card 3 all the way up to Card 6 and Card 7.
What I need help with is a formula that in the “Cheat Sheet” looks up i.e. Card 1’s abilities and Card 2’s abilities and see if they match a combo in the “Ability Combo” sheet and if it does, then it use a lookup formula to retrieve the points that the combo scores.
A made up example:
Card 1 has ability “PAPER”
Card 2 has ability “PENCIL”
A combination of “PAPER” and “PENCIL” returns ability combo “PAINTING” which scores +10 points in the deck.
In Excel I would have used something like:
=index(table;match(concatenate(Abil1,Abil2);_Ability_Combo;0);match(combo points;headers;0)
Any help would be highly appreciated
Best,
Joachim