In cell C17, create a nested formula using the INDEX and MATCH functions that returns the Number of participants for the Bedroom workshop type. How to do this in excel

Question

In cell C17, create a nested formula using the INDEX and MATCH functions that returns the Number of participants for the Bedroom workshop type. How to do this in excel

Answer 1

To create a nested formula using the INDEX and MATCH functions to return the Number of participants for the Bedroom workshop type in cell C17, follow these steps:

1. Enter the following formula in cell C17:

=INDEX($B$2:$D$13, MATCH("Bedroom", $A$2:$A$13, 0), MATCH("Number of participants", $B$1:$D$1, 0))

2. Press Enter to apply the formula.

This formula will first use the MATCH function to find the row number of the "Bedroom" workshop type in column A. Then, it will use the MATCH function to find the column number of the "Number of participants" heading in row 1. Finally, the INDEX function will return the value at the intersection of the row and column found by the MATCH functions, which will be the Number of participants for the Bedroom workshop type.