Search Results - Excelguru.ca

INDEX/MATCH using multiple worksheets with alphanumeric index value

Started by USAOz, 2020-11-03 08:11 AM

Replies: 1
Views: 264

Last Post By:: Last Post: 2020-11-06 11:01 AM; by alansidman

Forum:
Formulas

Having problem with an index match formula

Started by Nutsy, 2018-12-27 06:19 PM

Replies: 6
Views: 897

Last Post By:: Last Post: 2018-12-28 03:07 PM; by navic

Forum:
Formulas

sum values based off matches from two ranges

Started by Bl4ckPantha, 2018-11-01 08:56 AM

Replies: 9
Views: 3,190

Last Post By:: Last Post: 2018-11-10 05:40 PM; by ajko7

Forum:
Formulas

Search a data set and return adjacent cell values and sum them within one cell

Started by JonnyBravo, 2018-09-28 06:03 PM

index, match, sumif, sumproduct, vlookup

Replies: 3
Views: 880

Last Post By:: Last Post: 2018-09-28 07:58 PM; by JonnyBravo

Forum:
Formulas

MODE Formula based off an array using a lookup

Started by Bl4ckPantha, 2018-06-01 04:27 AM

Replies: 1
Views: 878

Last Post By:: Last Post: 2018-06-01 01:49 PM; by NBVC

Forum:
Formulas

Count of Pivot Column Data determined from a HLOOKUP?

Started by Bl4ckPantha, 2018-05-23 02:31 AM

Replies: 2
Views: 841

Last Post By:: Last Post: 2018-05-24 09:03 AM; by Bl4ckPantha

Forum:
Formulas

Return more than one match function

Started by bass23, 2018-04-30 03:26 PM

Replies: 1
Views: 740

Last Post By:: Last Post: 2018-04-30 06:49 PM; by Hercules1946

Forum:
Formulas

Using Multiple Tables to Match a Date Between Two Other Dates

Started by rosetc16, 2018-02-01 12:35 AM

Replies: 6
Views: 1,880

Last Post By:: Last Post: 2018-02-15 01:40 PM; by NBVC

Forum:
Formulas

Using VLOOKUP to Search for Multiple Occurrences with same Lookup Value

Started by rosetc16, 2018-02-08 04:31 PM

formula, function, index, match, vlookup

Replies: 4
Views: 1,410

Last Post By:: Last Post: 2018-02-08 11:53 PM; by rosetc16

Forum:
Formulas

Compare two columns and remove different values

Started by romper, 2017-06-18 04:31 PM

Replies: 1
Views: 950

Last Post By:: Last Post: 2017-06-18 05:48 PM; by Pecoflyer

Forum:
Formulas

Return value, INDEX MATCH

Started by nesheim, 2017-05-19 04:35 PM

Replies: 2
Views: 1,090

Last Post By:: Last Post: 2017-05-19 06:10 PM; by nesheim

Forum:
Formulas

Matching Criteria with IF Functions to return YES or NO for filtering (PLEASE HELP)

Started by rosetc16, 2017-04-22 02:28 AM

excel, if function, index, index match, match

Replies: 1
Views: 1,163

Last Post By:: Last Post: 2017-04-22 07:22 AM; by AliGW

Forum:
Formulas

Using ISNUMBER SEARCH with INDEX MATCH

Started by Emile, 2017-03-21 11:54 AM

Replies: 5
Views: 3,521

Last Post By:: Last Post: 2017-03-21 07:18 PM; by NBVC

Forum:
Formulas

Check a table & get the Start & end dates with values

Started by asokaw, 2017-02-04 06:21 AM

Replies: 1
Views: 1,088

Last Post By:: Last Post: 2017-02-05 04:04 PM; by Joris Moerings

Forum:
Formulas

Sorting duplicates into groupings

Started by Sabytiger, 2017-01-24 05:05 PM

2 Pages •: 1 2

Replies: 11
Views: 3,838

Last Post By:: Last Post: 2017-01-28 03:15 PM; by Hercules1946

Forum:
Formulas

Looking up value with 2 name match + row or column number.

Started by bilegt, 2017-01-24 05:18 AM

Replies: 4
Views: 1,608

Last Post By:: Last Post: 2017-01-24 03:56 PM; by Canapone

Forum:
Formulas

Index(Match FormulaArray Help VBA

Started by jgarvey23, 2017-01-03 09:36 PM

Replies: 1
Views: 1,589

Last Post By:: Last Post: 2017-01-10 01:52 AM; by p45cal

Forum:
VBA Programming

Index Match Function To Pull Multiple Rows Informations without Duplicates

Started by adamdeeakaaj, 2016-11-18 11:42 PM

iferror, index, match, no duplicates, small

Replies: 6
Views: 2,302

Last Post By:: Last Post: 2016-11-22 12:03 AM; by adamdeeakaaj

Forum:
Formulas

Calendar array to return unique results based on date and PO number

Started by jdefont, 2016-10-07 08:57 PM

Replies: 8
Views: 2,487

Last Post By:: Last Post: 2016-10-12 12:41 AM; by jdefont

Forum:
Formulas

Using Index and Counta, but ignore 0 values

Started by xl22, 2016-06-08 06:42 PM

Replies: 6
Views: 3,185

Last Post By:: Last Post: 2016-06-26 10:40 PM; by Hercules1946

Forum:
Formulas

data extracted from calendar

Started by kasper, 2016-04-20 10:07 PM

Replies: 4
Views: 1,837

Last Post By:: Last Post: 2016-05-04 10:09 PM; by kasper

Forum:
Formulas

Excel IF and MATCH formula?

Started by unisyko, 2016-04-30 12:47 AM

Replies: 2
Views: 1,421

Last Post By:: Last Post: 2016-04-30 05:25 PM; by Brian Smith

Forum:
Formulas

Copy values if a match against a range of value is found

Started by Wallaby, 2016-01-29 08:37 AM

Replies: 1
Views: 1,094

Last Post By:: Last Post: 2016-01-29 12:25 PM; by p45cal

Forum:
Formulas

Populating column in another sheet only if text is matching

Started by versace, 2015-12-08 09:05 PM

Replies: 7
Views: 3,958

Last Post By:: Last Post: 2015-12-10 10:06 PM; by navic

Forum:
Formulas

MATCH & INDEX (what am I missing)

Started by airpuncher, 2015-11-10 12:37 AM

Replies: 6
Views: 2,738

Last Post By:: Last Post: 2015-11-10 08:27 PM; by Pecoflyer

Forum:
Formulas

Search:

Search: Search took 0.01 seconds.

INDEX/MATCH using multiple worksheets with alphanumeric index value

Having problem with an index match formula

sum values based off matches from two ranges

Search a data set and return adjacent cell values and sum them within one cell

MODE Formula based off an array using a lookup

Count of Pivot Column Data determined from a HLOOKUP?

Return more than one match function

Using Multiple Tables to Match a Date Between Two Other Dates

Using VLOOKUP to Search for Multiple Occurrences with same Lookup Value

Compare two columns and remove different values

Return value, INDEX MATCH

Matching Criteria with IF Functions to return YES or NO for filtering (PLEASE HELP)

Using ISNUMBER SEARCH with INDEX MATCH

Check a table & get the Start & end dates with values

Sorting duplicates into groupings

Looking up value with 2 name match + row or column number.

Index(Match FormulaArray Help VBA

Index Match Function To Pull Multiple Rows Informations without Duplicates

Calendar array to return unique results based on date and PO number

Using Index and Counta, but ignore 0 values

data extracted from calendar

Excel IF and MATCH formula?

Copy values if a match against a range of value is found

Populating column in another sheet only if text is matching

MATCH & INDEX (what am I missing)