Question: Case 5: Learning to use MATCH and INDEX functions Research the MATCH and INDEX functions in Excel. Identify some scenarios where MATCH and INDEX can

Case 5: Learning to use MATCH and INDEX functions Research the MATCH and INDEX functions in Excel. Identify some scenarios where MATCH and INDEX can be useful. Instructions: - Create a business case where using MATCH and INDEX are useful. Use several sentences to describe what the data is about and why you are using MATCH and INDEX. - Create some text or data for your business case and then use the two functions. This can be on the same worksheet as your scenario description or a second worksheet. - If you found a business case and data on the internet, you must make some changes to the case and data. You cannot use the exact same thing. - MATCH and INDEX can be used together or separately
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
