index/match - Search Results - Excel Help Forum

[SOLVED] Merging INDEX & SUMPRODUCT formula

Started by kapi98‎, 05-12-2023 07:16 PM

6

602

Last Post By:: Last Post: 05-16-2023 05:41 AM; by leelnich

Forum:
Excel Formulas & Functions

[SOLVED] Dynamic array formula to return nth occurrence

Started by Marbleking‎, 11-28-2022 10:21 AM

dynamic array formula, index/match, nth lookup, spill range

9

384

Last Post By:: Last Post: 11-29-2022 09:16 AM; by Fluff13

Forum:
Excel Formulas & Functions

I know another index match question

Started by copperwood‎, 10-31-2022 12:32 PM

7

274

Last Post By:: Last Post: 10-31-2022 11:56 PM; by FDibbins

Forum:
Excel Formulas & Functions

Need to list unique values from (3) separate table columns

Started by jvcalandra‎, 08-22-2022 02:29 PM

12

439

Last Post By:: Last Post: 08-23-2022 05:23 AM; by HansDouwe

Forum:
Excel Formulas & Functions

Index/Match Formula with nested error test that has an error that is unsolvable!

Started by USAOz‎, 05-24-2022 01:06 AM

error checking, excel, index/match, microsoft 365, windows 10 latest

6

390

Last Post By:: Last Post: 05-24-2022 04:05 AM; by AliGW

Forum:
Excel Formulas & Functions

Updating lookups from a closed spreadsheet

Started by cmoexcel‎, 12-10-2020 09:59 PM

closed excel files, index/match, vlookup

12

1,524

Last Post By:: Last Post: 12-14-2020 11:58 AM; by 6StringJazzer

Forum:
Excel General

[SOLVED] Index/Match formula not working properly from data in Pivot Tables - HELP!

Started by Pooger‎, 12-04-2020 04:42 PM

7

1,145

Last Post By:: Last Post: 12-07-2020 04:24 PM; by Pooger

Forum:
Excel Formulas & Functions

Array Formulas with Multiple Range Criterias - not returning result

Started by stearno‎, 11-05-2020 04:13 AM

1

401

Last Post By:: Last Post: 11-10-2020 01:56 AM; by BMV

Forum:
Excel Formulas & Functions

Get results in a column filtered by multiple criteria

Started by DanielleHeid‎, 04-17-2020 07:53 PM

countifs, index/match, multiple vales vlookup

1

410

Last Post By:: Last Post: 04-17-2020 08:31 PM; by Sam Capricci

Forum:
Excel Formulas & Functions

Need to Identify Blank Cell Locations, Index them, and Assign them values

Started by jmoore_13‎, 11-12-2019 04:13 PM

3

377

Last Post By:: Last Post: 11-13-2019 01:55 AM; by Mrrrr

Forum:
Excel Formulas & Functions

Index Match using Multiple Criteria and pulling multiple values

Started by jmoore_13‎, 11-08-2019 03:44 PM

index/match, index/match array, index/match two columns, index/match/if/or

4

457

Last Post By:: Last Post: 11-08-2019 05:37 PM; by jmoore_13

Forum:
Excel Formulas & Functions

[SOLVED] Lookup values from Pivot Table according to multiple criteria

Started by awesusan‎, 04-17-2019 02:30 AM

5

1,824

Last Post By:: Last Post: 04-25-2019 10:26 PM; by JeteMc

Forum:
Excel Formulas & Functions

Longer Formulas vs. More Formulas?

Started by eNinjaInTraining‎, 01-03-2019 11:10 AM

1

390

Last Post By:: Last Post: 01-03-2019 11:48 AM; by MrShorty

Forum:
Excel Formulas & Functions

[SOLVED] #N/A index/match formula recognized as Text not Value

Started by Spyderwoman‎, 12-10-2018 02:07 PM

#n/a, activecell.text, activecell.value, index/match

2

467

Last Post By:: Last Post: 12-10-2018 04:03 PM; by Spyderwoman

Forum:
Excel Programming / VBA / Macros

[SOLVED] Multiples Index/Match/Multiples Columns But to be concatenate in respective Rows

Started by AndyJr‎, 12-02-2018 11:14 PM

concatenate, index/match, multiples columns

23

1,018

Last Post By:: Last Post: 12-09-2018 11:21 PM; by jindon

Forum:
Excel Programming / VBA / Macros

Dashboard - need to pull data from multiple feeder sheets

Started by BigErnKingpin‎, 05-31-2018 09:05 AM

dashboard, index/match, indirect, named ranges, pivot tables; multiple

3

1,425

Last Post By:: Last Post: 05-31-2018 10:28 AM; by sandy666

Forum:
Excel Formulas & Functions

[SOLVED] Four IF statements needed in one cell for correct quarterly calculations

Started by dgrissom‎, 04-27-2018 03:06 PM

if/then functions, if/then/else, index array, index/match

9

493

Last Post By:: Last Post: 04-27-2018 04:17 PM; by Sam Capricci

Forum:
Excel Formulas & Functions

calculate amount charged based on various rates

Started by imran999‎, 03-13-2018 09:31 PM

4

783

Last Post By:: Last Post: 03-14-2018 03:48 AM; by imran999

Forum:
Excel Formulas & Functions

[SOLVED] Nested IF statements with INDEX/MATCH instead of VLOOKUP

Started by LKERN‎, 11-11-2017 09:43 PM

7

2,253

Last Post By:: Last Post: 11-12-2017 02:24 PM; by leelnich

Forum:
Excel Formulas & Functions

Help needed with userform label and Index/Match

Started by mrscottjr‎, 11-10-2017 11:13 PM

index/match, labels, tables, userforms, vba

1

859

Last Post By:: Last Post: 11-11-2017 02:42 AM; by Kaper

Forum:
Excel Programming / VBA / Macros

[SOLVED] Search for cell value; look up last number value in row, sum those values

Started by Gregbaron‎, 11-03-2017 10:49 AM

index/match, last cell, search for value

4

584

Last Post By:: Last Post: 11-03-2017 08:48 PM; by leelnich

Forum:
Excel Formulas & Functions

Bringing an index/match function over to vba

Started by nhlbond‎, 07-05-2017 04:34 PM

9

492

Last Post By:: Last Post: 07-06-2017 01:31 PM; by CK76

Forum:
Excel Programming / VBA / Macros

[SOLVED] Lookup (index/match) and return column headers

Started by Barslund‎, 06-08-2017 04:54 AM

6

6,542

Last Post By:: Last Post: 06-08-2017 06:01 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] Retrieving multiple cell info from a worksheet 2 and show results on worksheet 1

Started by dave57‎, 05-23-2017 08:38 AM

index/match, multiple cell search, multiple sheet search, vlookup

27

928

Last Post By:: Last Post: 05-25-2017 08:32 AM; by dave57

Forum:
Excel Formulas & Functions

[SOLVED] Help with Index/Match using names

Started by moura‎, 08-29-2016 11:43 AM

18

2,408

Last Post By:: Last Post: 09-01-2016 02:45 PM; by oeldere

Forum:
Excel Formulas & Functions

[SOLVED] Matching specific characters in a row using INDEX/MATCH

Started by Phalanxz‎, 04-12-2016 04:16 PM

6

1,200

Last Post By:: Last Post: 04-13-2016 03:42 PM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] IF to check a calculation result

Started by TheAssistant‎, 01-21-2016 07:47 PM

calculations, if function, if statements, index/match

3

690

Last Post By:: Last Post: 01-21-2016 08:03 PM; by Jonmo1

Forum:
Excel Formulas & Functions

copying column headers from multiple sheets into a "summary" sheet, based on criteria

Started by danJ6989‎, 12-09-2015 03:59 AM

2

763

Last Post By:: Last Post: 12-09-2015 05:43 AM; by danJ6989

Forum:
Excel Formulas & Functions

Index Match with Multiple Criteria - Problems

Started by almugs‎, 11-24-2015 10:59 AM

14

2,146

Last Post By:: Last Post: 11-25-2015 12:50 PM; by almugs

Forum:
Excel Formulas & Functions

Index/Match with multiple Criteria

Started by almugs‎, 11-24-2015 07:49 AM

0

420

Last Post By:: Last Post: 11-24-2015 07:49 AM; by almugs

Forum:
Excel Formulas & Functions

Index/Match array help please

Started by EimearC‎, 11-17-2015 09:46 PM

5

826

Last Post By:: Last Post: 11-17-2015 11:52 PM; by EimearC

Forum:
Excel General

Finding price with duplicate Quantity values

Started by grantjw‎, 04-01-2015 03:37 PM

2

612

Last Post By:: Last Post: 04-02-2015 09:06 AM; by grantjw

Forum:
Excel Formulas & Functions

Sort filtered results of INDEX/MATCH from drop down using 3 criteria

Started by lorikgator‎, 03-13-2015 05:33 PM

3 criteria, index/match, sort array, sorting

0

878

Last Post By:: Last Post: 03-13-2015 05:33 PM; by lorikgator

Forum:
Excel Formulas & Functions

[SOLVED] Sumifs Row equals a date, multiple criteria

Started by nickmessick1‎, 12-04-2014 05:20 PM

2

1,313

Last Post By:: Last Post: 12-04-2014 05:45 PM; by ChemistB

Forum:
Excel Formulas & Functions

[SOLVED] Matching Multiple Cells in Two Tables Simultaneously

Started by djmyers‎, 09-30-2014 12:21 PM

conditional formatting, index/match, multiple conditions

5

1,028

Last Post By:: Last Post: 09-30-2014 01:52 PM; by sktneer

Forum:
Excel General

Search:

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Merging INDEX & SUMPRODUCT formula

[SOLVED] Dynamic array formula to return nth occurrence

I know another index match question

Need to list unique values from (3) separate table columns

Index/Match Formula with nested error test that has an error that is unsolvable!

Updating lookups from a closed spreadsheet

[SOLVED] Index/Match formula not working properly from data in Pivot Tables - HELP!

Array Formulas with Multiple Range Criterias - not returning result

Get results in a column filtered by multiple criteria

Need to Identify Blank Cell Locations, Index them, and Assign them values

Index Match using Multiple Criteria and pulling multiple values

[SOLVED] Lookup values from Pivot Table according to multiple criteria

Longer Formulas vs. More Formulas?

[SOLVED] #N/A index/match formula recognized as Text not Value

[SOLVED] Multiples Index/Match/Multiples Columns But to be concatenate in respective Rows

Dashboard - need to pull data from multiple feeder sheets

[SOLVED] Four IF statements needed in one cell for correct quarterly calculations

calculate amount charged based on various rates

[SOLVED] Nested IF statements with INDEX/MATCH instead of VLOOKUP

Help needed with userform label and Index/Match

[SOLVED] Search for cell value; look up last number value in row, sum those values

Bringing an index/match function over to vba

[SOLVED] Lookup (index/match) and return column headers

[SOLVED] Retrieving multiple cell info from a worksheet 2 and show results on worksheet 1

[SOLVED] Help with Index/Match using names

[SOLVED] Matching specific characters in a row using INDEX/MATCH

[SOLVED] IF to check a calculation result

copying column headers from multiple sheets into a "summary" sheet, based on criteria

Index Match with Multiple Criteria - Problems

Index/Match with multiple Criteria

Index/Match array help please

Finding price with duplicate Quantity values

Sort filtered results of INDEX/MATCH from drop down using 3 criteria

[SOLVED] Sumifs Row equals a date, multiple criteria

[SOLVED] Matching Multiple Cells in Two Tables Simultaneously