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.

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

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

Jun 2, 2022 · 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.

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 …

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 …

Apr 1, 2019 · Hi there, I currently have an INDEX MATCH formula which is working across 2 spreadsheets and returning the value of the cell I want it to, but I want it to return the reference …

Jan 7, 2022 · INDEX not updating Hello, I have made a file with an INDEX-formula to get information from another file. The problem is that the results don't update unless I select the …

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 …

Aug 24, 2021 · How to Index Match from multiple closed workbooks in excel. Dear Tech Community, I am trying to reference multiple closed Excel workbooks with different file paths …