Mistermind
New Member
I'm trying to figure out the right way to reference a value in a table based on a different value.
This sheet is supposed to calculate scores for a Poker league that I am in. I put in a table that has the values for the scoring. What I want it to do is when I type in my placement in Column D it references the Rank Column of my Scores Table and Returns the Baseline score and adds to it the Bonus multiplied by the number of players that I have in Column E.
I tried just writing an IF statement but it Spills down 20 Rows. I also tried MATCH and VLOOKUP but I couldn't get them to function correctly. I could write an IFS with 40 arguments but there has to be a better way to do it.
Thanks for any help you can provide.
EDIT: I can't delete this (or can't figure out how) but I realized I was making it hard on myself trying to match Strings when I could just make the Ranks Integers and use INDEX to find the right Row based on that. Thanks anyway.
This sheet is supposed to calculate scores for a Poker league that I am in. I put in a table that has the values for the scoring. What I want it to do is when I type in my placement in Column D it references the Rank Column of my Scores Table and Returns the Baseline score and adds to it the Bonus multiplied by the number of players that I have in Column E.
I tried just writing an IF statement but it Spills down 20 Rows. I also tried MATCH and VLOOKUP but I couldn't get them to function correctly. I could write an IFS with 40 arguments but there has to be a better way to do it.
Thanks for any help you can provide.
EDIT: I can't delete this (or can't figure out how) but I realized I was making it hard on myself trying to match Strings when I could just make the Ranks Integers and use INDEX to find the right Row based on that. Thanks anyway.
Last edited:
