Search:

Tag: index & match

Page 1 of 9 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Sum YTD and Quarters using Index and Match and Sumifs between months across columns

    Started by jconaghan‎, 11-30-2019 07:43 AM
    index & match, qtd, sumifs, sumifs & dates, ytd 4 Attachment(s)
    • 153
    Last Post: 12-02-2019 05:47 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Index match with condition from second index match

    Started by scharpentier‎, 11-19-2019 08:36 AM
    index, index & match, index and match and if 2 Attachment(s)
    • 88
    Last Post: 11-19-2019 11:05 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Subtotal with index and match function

    Started by soreno‎, 11-16-2019 03:32 AM
    index & match, subtotal formula 1 Attachment(s)
    • 119
    Last Post: 11-19-2019 02:27 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Index Match for multiple results in one cell

    Started by Wizards‎, 11-01-2019 12:42 AM
    index & match, index and match and if, index and small, index and small and if 1 Attachment(s)
    • 126
    Last Post: 11-01-2019 11:44 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] INDEX/MATCH with columns containing formulas

    Started by Tambe257‎, 10-12-2019 01:08 PM
    index & match 2 Attachment(s)
    • 136
    Last Post: 10-13-2019 12:14 AM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Search for a value in a row, return list of cells below that particular cell

    Started by fendersony‎, 08-20-2019 03:03 AM
    index, index & match, return cells 3 Attachment(s)
    • 198
    Last Post: 08-20-2019 06:09 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Find Unique ID - then find last occurrence of a value

    Started by DTK0902‎, 08-15-2019 06:09 AM
    excel, index & match 2 Attachment(s)
    • 182
    Last Post: 08-19-2019 09:09 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Error in Excel VBA code using SumIfs/Index/Match

    Started by HelpPlease715‎, 08-14-2019 09:37 AM
    index & match, sumifs, userform
    • 89
    Last Post: 08-14-2019 11:52 AM
    by AliGW  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  9. [SOLVED] Dynamic Index/Match formula based on drop down and check boxes

    Started by Phil123456789‎, 07-22-2019 09:11 AM
    check box, index, index & match, match, match & index 2 Attachment(s)
    • 127
    Last Post: 08-01-2019 11:05 AM
    by CAntosh  Go to last post

    Forum:
    Excel Formulas & Functions

  10. How to locate a row matching 6 criteria and output the last value of the row

    Started by HBelevators‎, 07-03-2019 04:15 PM
    ifs and lookups, index, index & match, match, vlookup 1 Attachment(s)
    • 104
    Last Post: 07-03-2019 07:11 PM
    by jason.b75  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] I need to convert a vlookup formula into an INDEX MATCH.

    Started by ButterLord‎, 07-01-2019 11:22 AM
    index, index & match, index + match, match, vlookup
    • 152
    Last Post: 07-01-2019 12:46 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Index Match to closed Workbook

    Started by Gazsim‎, 06-27-2019 09:43 AM
    index & match 1 Attachment(s)
    • 159
    Last Post: 07-01-2019 12:31 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Populate Calendar (names/Dates) with Names and Dates ranges as data

    Started by picsou‎, 06-18-2019 10:24 AM
    array formula, calendar, dates in formulae, index & match, sumproduct 2 Attachment(s)
    • 254
    Last Post: 06-24-2019 10:37 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] VLOOKUP Function not working properly

    Started by ibdanny83‎, 06-07-2019 12:03 PM
    index & match, vlookup 1 Attachment(s)
    • 142
    Last Post: 06-07-2019 01:17 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  15. how to use match if if statement or better way to solve this problem?

    Started by eddie01001‎, 06-06-2019 12:48 AM
    index & match, index and match and if, match
    • 93
    Last Post: 06-06-2019 12:55 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  16. How do I find most recent dates for one person with repeated values in no specific order?

    Started by louhilla‎, 05-14-2019 04:49 PM
    array, index & match, large, max 1 Attachment(s)
    • 173
    Last Post: 05-15-2019 02:56 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Listing all matches from index/match search

    Started by tw1809‎, 05-14-2019 01:21 PM
    index & match 2 Attachment(s)
    • 188
    Last Post: 05-16-2019 11:04 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] VBA Index Match Odd Fault

    Started by gillooleyj‎, 05-10-2019 09:48 AM
    index & match, vba 3 Attachment(s)
    • 86
    Last Post: 05-10-2019 10:02 AM
    by gillooleyj  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  19. [SOLVED] Lookup cell value based on multiple criteria

    Started by cherias‎, 05-06-2019 11:50 AM
    combo box dynamic link, formula, index & match, scroll bar 8 Attachment(s)
    • 242
    Last Post: 05-09-2019 10:14 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Transforming Data Set

    Started by d7882‎, 03-25-2019 11:30 AM
    array, index & match, vlook up 1 Attachment(s)
    • 165
    Last Post: 03-25-2019 12:16 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] Multiple return Index match or better look up

    Started by Shruder‎, 03-21-2019 07:39 PM
    index & match, vlook up 3 Attachment(s)
    • 131
    Last Post: 03-22-2019 06:19 PM
    by Shruder  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] SUMPRODUCT / SUMIF based on both row and column criteria

    Started by Phil123456789‎, 03-21-2019 04:50 AM
    index & match, sum - range of cells, sumproduct conditinal sum, sumproduct formula modify, sumproduct index match 6 Attachment(s)
    • 314
    Last Post: 03-22-2019 08:35 AM
    by Phil123456789  Go to last post

    Forum:
    Excel Formulas & Functions

  23. Auto lookup of rate table excluding not applicable

    Started by Gazsim‎, 03-14-2019 11:46 AM
    index & match 2 Attachment(s)
    • 114
    Last Post: 03-14-2019 01:35 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Index / Match with IF?

    Started by Gazsim‎, 02-15-2019 07:18 AM
    index & match, index and match and if 1 Attachment(s)
    • 88
    Last Post: 02-15-2019 07:43 AM
    by Gazsim  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Index & Match, Three Criteria Rows & Columns.

    Started by Gazsim‎, 02-13-2019 12:35 PM
    index & match, multiple criteria 1 Attachment(s)
    • 169
    Last Post: 02-14-2019 10:56 AM
    by 63falcondude  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Compare list with another column, take rows where true, match to another column value

    Started by fly545‎, 01-23-2019 02:14 AM
    2 Pages •
    1 2
    array conditional, array dynamic, index & match, list check, multiple results 6 Attachment(s)
    • 349
    Last Post: 01-28-2019 09:52 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] INDEX MATCH ARRAY with multiple criteria

    Started by StoneQuill‎, 01-15-2019 03:37 PM
    array index, index, index & match, index and small, index and small and if
    • 678
    Last Post: 01-17-2019 01:34 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Vlookup match two variables from two tables

    Started by d7882‎, 01-07-2019 12:56 PM
    index & match, vlookup 2 Attachment(s)
    • 243
    Last Post: 01-07-2019 02:19 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Roster Days to Hours per Week?

    Started by Gazsim‎, 12-14-2018 09:27 AM
    index & match, vlookup + index + match 4 Attachment(s)
    • 220
    Last Post: 12-17-2018 10:32 AM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Help, confused with index match return cell adjacent to a value

    Started by Iceman86‎, 12-14-2018 06:44 AM
    array formula, cell adjacent, index & match 3 Attachment(s)
    • 141
    Last Post: 12-14-2018 09:30 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Having trouble with ActiveX Textboxes

    Started by MaxSoltau‎, 11-23-2018 03:58 AM
    2 Pages •
    1 2
    activex combobox text, index & match, linked cell property 3 Attachment(s)
    • 277
    Last Post: 12-05-2018 03:13 AM
    by Keebellah  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  32. [SOLVED] Formula to alphabetize names not working

    Started by Stuepef‎, 10-19-2018 09:56 AM
    alphabetcal rank, countif based on criteria, excel, index & match 1 Attachment(s)
    • 230
    Last Post: 10-19-2018 11:39 AM
    by Stuepef  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Understanding a formula

    Started by Tlarkin‎, 10-16-2018 05:04 AM
    complex, index & match
    • 152
    Last Post: 10-16-2018 04:37 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Lookup names based on multiple drop-down lists

    Started by ClickingNoise‎, 10-09-2018 04:42 AM
    data valadation, index & match, lookups 4 Attachment(s)
    • 157
    Last Post: 10-10-2018 08:43 AM
    by ClickingNoise  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Formula that allows another formula to be used if the first formula results in NA.

    Started by jellyvixx‎, 10-08-2018 09:57 AM
    excel, index & match, index + match
    • 122
    Last Post: 10-08-2018 10:29 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

Results 1 to 35 of 292
Page 1 of 9 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1