## Summing Multiple Index-Match Formulas

I would like to sum multiple index-match formulas in one cell. Trying to manually add them led me to a character limit error.  I want to multiply two …

## Compare two values in an array and if they match in a row, return a value from the third column in the same row.

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

## FORMULA HELP COMPARING TWO COLUMNS OF DATA THAT ARE NOT AN EXACT MATCH

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation.  I …

## How to search through items with the same value to see if the meet criteria?

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

## How to search through items with the same value to see if the meet criteria?

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

## Add Criteria to existing Index Formula

I have a summary sheet where I’m trying to create a list of all of the people that meet a criteria.  That formula is working, but it is giving me …

## Index and Match: Copy Values based on Matching Cells

I need to fill in blank cells with valued cells based on matching cells in two different worksheets.   BESTRFS Table (Link)   MASTERCap Table …

## Match Text and Numerical Criteria, then Rank

Hello, I need some assistance with a formula in calculating the best performer of a certain category. I work in real estate sales, and essentially I want to be …

## INDEX Array problems

Hi AllI have a formula, that works! (Hooray!) But only with a manual entered INDEX array..The working formula …

## Special Lookup

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the …

Is there a formula to link excel files in google drive whilst the source file is closed? By:

## Architect

Hi everyone, I would really appreciate if someone could help me regarding a function I am trying to execute on Excel.   By:

## VLookup??

Hi I am looking for a solution to a problem in excel when trying to build a ss for a logistics company as followsIf column A has start point for a truckColumn …

## Offset, index or match – or combination?

Would like to autopopulate B2:B5 by picking up B1 and cross-referenceing to the Actors List tab (I’m guessing INDEX, OFFSET and/or MATCH). Will upload …

## How to extract value from Pivot Table

How do I extract value from Pivot Table to a Table in another sheet from the same workbook. For this instance extracting the Avg Price in the Pivor to Product …

## How to extract value from Pivot Table

How do I extract value from Pivot Table to a Table in another sheet from the same workbook. For this instance extracting the Avg Price in the Pivor to Product …

## Reference a named range in an index formula

Hello this is my first post I have been hitting my head against a wall for a bit now trying to figure this out.  I am running excel 2010 with windows 7 At …

## Find column header name and return multiple match values

Hi All, I currently have an index formula in place that returns all results matching multiple criteria: raw material, period (falling between the start and end …

## Combining lookup with matrix

Hi all,   I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

## EXCEL HELP

Hi, I have to create a searcher using INDEX and MATCH function in Excel. I’ve made a billionaire’s datasheet in a seperate sheet in the same …

## How to sum multiple rows and columns

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

## Index Match Match with Two If Statements

/* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; …

## MR1984

Items Month Wk 10 Wk 11 Wk 12 Wk 13   Current Week Item 1 Item 2 Item 3 Item 12 Item 1 Mar 110 210 310 1210   Demand Item 1 Apr 120 220 320 1220 …

## VLOOKUP & IF OR MATCH/INDEX

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

## Financial Analyst

I am trying to use indirect and index match and make the row number reference another cell. My formula is this …

## Find Salary in Range

Hi – I am attempting to match a employee’s salary with the nearest value (rounded up) in a range. For example: Employee A — \$45,000 — …