Hi all,
I hope you're all doing well
I have the following table (this is just dummy data, for all the sports fans who read this ), and I want to get the correct numbers from the table on the left into the correct fields in the table on the right, e.g. G13 into N13. I've found an index match formula with multiple criteria online, i.e. one that let's me specify that I want the 2006 Football wins. I've tried to add another criterion to specify that I want only the Germany ones but I've run into this error and I have a strong suspicion that it's because I don't actually understand the syntax of the formula. Does anyone have any suggestions for how to do this? I need to solve this because I need to be able to change K12 as I wish with the formula already in place, so that I can get whichever country's results whenever I need them.
Thanks so much for any help!!
I hope you're all doing well
I have the following table (this is just dummy data, for all the sports fans who read this ), and I want to get the correct numbers from the table on the left into the correct fields in the table on the right, e.g. G13 into N13. I've found an index match formula with multiple criteria online, i.e. one that let's me specify that I want the 2006 Football wins. I've tried to add another criterion to specify that I want only the Germany ones but I've run into this error and I have a strong suspicion that it's because I don't actually understand the syntax of the formula. Does anyone have any suggestions for how to do this? I need to solve this because I need to be able to change K12 as I wish with the formula already in place, so that I can get whichever country's results whenever I need them.
Thanks so much for any help!!