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 have a data sheet with all the data. In my current sheet I would like it to return a list of all the names matching these two criteria. My formula is as follows:
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 assign each person to each task, and tab three is where I keep all my formulaes safe 😖.
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.
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.
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 table currently contains three of the seven data fields that I'm looking to get information from.
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,...
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 Ctry match Sheet1, or exclude all entries on Sheet2 where the ID matches any of the ID's listed on Sheet1 regardless of Category and Ctry.
kbloggs21 To apply conditional formatting using Index Match in Excel, you can follow these steps: Select the range of cells that you want to format in Table 1. Go to the "Home" tab in the Excel ribbon. Click on the "Conditional Formatting" button. From the drop-down menu, select "New Rule." In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format." In ...
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 of the cell instead of the value it contains. I keep getting different errors when I try to use the address function.
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, sometimes the players have the same score and my formulas end up showing the them as #N/A. I have enclosed an image to better demonstrate my issue.
