Hello,
I am doing an online course on excel. I am really stuck on one question. I can solve the problem with index, match but the exam requires me to use a single array formula. I am attaching the screenshot of the question, a screenshot of the necessary tables and if needed the whole file. please give me a solution.....Thanks.
I am doing an online course on excel. I am really stuck on one question. I can solve the problem with index, match but the exam requires me to use a single array formula. I am attaching the screenshot of the question, a screenshot of the necessary tables and if needed the whole file. please give me a solution.....Thanks.