# If combination of two variables X and Y matches combo XY, return points of combo XY

Topic Labels: Formulas
325 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

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.

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: