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 …

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 …

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 …

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 …

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.

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

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 …

Aug 15, 2023 · INDEX ('Tab 2'!J:J, ...) returns the value in column J of Tab 2 at the position returned by the MATCH function. Please replace 'Tab 2' with the actual name of your second …

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 …

The index/match formula in your original post is indicative of a lookup function, not a sum function. But, it still depends on whether you want to exclude the entries where the ID, Category, and …