INDEX MATCH function, avoid duplicate returns
Feb 22, 2020 · INDEX MATCH function, avoid duplicate returns Hi everyone! I'm working on a sheet for work. I am on my last task and can't seem to figure this one out. I'm hoping someone can help: I …
How to correct "#N/A" when using Rank function and Index function
Jul 7, 2025 · How to correct "#N/A" when using Rank function and Index function I am trying to create somewhat of a scoreboard that eliminates the lowest ranking player per level. The problem is, …
Excel #SPILL error with INDEX formula | Microsoft Community Hub
Feb 11, 2021 · Hello, I have been using the INDEX formula for years. I use the formula to input data from one sheet into another matching on a common cell (eg,...
Can you use AND / OR in an INDEX MATCH | Microsoft Community Hub
Oct 27, 2017 · I have a dashboard setup across three tabs on excel to assign people their work tasks, tab one is the easy read dashboard, second is the data sheet with all the tasks and where I can …
Combining IF and INDEX functions | Microsoft Community Hub
Dec 15, 2017 · Combining IF and INDEX functions I'm trying to find a formula that will allow me to display multiple fields of data when a specific value (a product SKU) is entered into a cell.
#REF! error in INDEX/MATCH formula | Microsoft Community Hub
Jun 2, 2022 · Hi Caro_Bloggs the first part of your INDEX formula refers to just one column (K11:K93), but with the very last argument you refer to colum 11. So if you want to return the value of column …
Index and Match with a pivot table | Microsoft Community Hub
Mar 26, 2019 · Index and Match with a pivot table Hi, I am working on making our sales reports less manual entry and want to use formulas to grab from a pivot table that has all our data. The pivot …
Index, match and max function with specific criteria
Sep 28, 2020 · Hello, I am using the following formula to index and match a row with the highest value. =INDEX (A5:A35,MATCH (MAX (G5:G35),G5:G35,0)) I would like to add an IF statement with a …
How can I avoid duplicate values being returned with INDEX MATCH?
Jun 20, 2023 · I'm trying to return the top 10 worst percentages with a LARGE function, and then in an adjacent column, use the INDEX MATCH functions to return which question corresponds with the % …
Can't fix #REF! with INDEX | Microsoft Community Hub
Mar 27, 2024 · The table on the INDEX sheet has been named Index: So when you use Index in a formula, Excel thinks you refer to the table, but then you cannot use it as a function.