Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
This seems to be looking at the outcome of a bracket in which successive players show an outcome. The table can be easily created by looking at each combination of players and listing them in the t...
Answer
#1: Initial revision
by
Sigma
·
2020-10-19T19:36:17Z (about 4 years ago)
This seems to be looking at the outcome of a bracket in which successive players show an outcome. The table can be easily created by looking at each combination of players and listing them in the table using the index-match combination to find the correct value. Combinations that are not found in the table will return a #N/A error, and we can use iferror to show an exception. The formula in column D should be a simple concatenation of the values in columns A and B: ```=A2&B2``` The formula in the top left cell of the table should should be: ```=iferror(INDEX($A$1:$C$6,MATCH($F2&G$1,$D:$D,0),3),"x")``` Copy & paste to fill the rest of the cells. 