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 …

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, …

Jul 1, 2022 · Index function with Indirect function within Hello, I am new to excel goin to college for it and Im struggling with a problem. I need to create a formula In cell N5, enter an INDEX function that will …

Oct 27, 2017 · Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.

Jun 28, 2023 · Click "OK" to apply the conditional formatting rule. This formula uses the INDEX and MATCH functions together. It looks up the Employee ID in Table 1 and matches it with the Employee …

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.

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,...

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.

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 …

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 …