Final answer:
To identify the designer of Spirit Pins using Excel, you would use the INDEX function with a nested MATCH function to search within a specified range of designer names and return the name associated with 'Spirit Pins'.
Step-by-step explanation:
To find the name of the designer of Spirit Pins using the INDEX and MATCH functions in Excel, you need to follow these steps:
Click on cell B3 where you want the result to be displayed.
Enter the INDEX function, which will return the value from a specific location in a table or range:
Inside the INDEX function, specify the range where the designer names are located (A6:A27).
Nested within the INDEX function, use the MATCH function to find the row number where 'Spirit Pins' is located in the range that describes the items designed:
The MATCH function will look for the text 'Spirit Pins' in the specified range and return its relative position within that range.
Close the formulas so that the MATCH function is nested inside the INDEX function.
The complete formula will look something like this: =INDEX(A6:A27, MATCH("Spirit Pins", B6:B27, 0)).
Press Enter to display the result - the name of the designer who designed Spirit Pins.