Comments on: How to Use INDEX and MATCH Functions in Excel (14 Suitable Examples)

By: Shamima Sultana

Shamima Sultana — Wed, 26 Apr 2023 06:19:53 +0000

In reply to Rich Saunders. Dear Rich Saunders, Query 1: The method 7 works just fine. If you write March in F4, you will get the values for that month as well. Query 2: The formula is universal for any Excel version. If you write the formula in any cell the formula will get you the entire row value for the name you will write in the F4 cell. For example, if you write “Nathan” in F4 cell and paste the formula in the A1 cell then the formula will write the values of the entire row( B8:D8) in the A1:A3 range. Yes, we should have mentioned the Ctrl+Shift+Enter in the article. We will make sure of that in the next articles. As we used Microsoft 365 so it works by pressing Enter. We are sorry for that. Regards ExcelDemy

By: Rich Saunders

Rich Saunders — Tue, 18 Apr 2023 13:45:10 +0000

How to Use INDEX MATCH Formula in Excel (9 Examples) – Problems encountered
1) Step #7 contains three (3) months your solution contains ONLY two (2) months- What about March
2) Step #8 DOES NOT WORK – when you type a formula into A (ONE) cell the results will NOT populate 2 cells to the right. What is the formula utilized to obtain the data within the 2nd & 3rd cell????????? Does this formula only work in a particular Excel Version? 365?? Also, the only way I could get the function to work for the “Salesman” – Frank response was to utilized Ctrl + Shift + Enter Correct???????????????/ If the user needs to utilize Ctrl + Shift + Enter – Would be great if you ADVISED us of this necessity