Search:

Tag: index & match

Page 1 of 9 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Dynamic Filter Search to pull similar data from the specific value searched

    Started by Tgbell‎, Yesterday 09:57 AM
    critera, index & match, look-up 4 Attachment(s)
    • 325
    Last Post: Yesterday 04:54 PM
    by Bernie Deitrick  Go to last post

    Forum:
    Excel General

  2. [SOLVED] For each code, i want to rank the outlet by qty sold (largest to smallest)

    Started by sillston‎, 06-22-2020 07:06 PM
    index & match, large and small, rank, vlookup + index + match 1 Attachment(s)
    • 94
    Last Post: 06-23-2020 12:47 AM
    by sillston  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Index Match: search for a string and return multiple values

    Started by Zexall‎, 04-22-2020 08:34 PM
    index & match, lookup 2 Attachment(s)
    • 118
    Last Post: 04-23-2020 09:20 AM
    by Zexall  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] How to use INDEX and MATCH to replace VLOOKUP?

    Started by jrtaylor‎, 03-27-2020 04:26 PM
    index & match, vlookup 1 Attachment(s)
    • 104
    Last Post: 03-27-2020 05:49 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Finding Closest Match For Rows

    Started by mjm1013‎, 01-28-2020 01:29 PM
    index & match, index and match, match, match & index, match and index 1 Attachment(s)
    • 114
    Last Post: 01-28-2020 04:13 PM
    by mjm1013  Go to last post

    Forum:
    Excel Formulas & Functions

  6. SumIf to a Specified Value

    Started by RossMo21‎, 01-24-2020 03:37 PM
    index & match, indirect & match, sum, sumif, sumproduct 2 Attachment(s)
    • 135
    Last Post: 01-28-2020 12:33 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Vlookup and drop down

    Started by johnny4strings‎, 01-13-2020 11:49 PM
    dropdown, index & match, vlook up 3 Attachment(s)
    • 345
    Last Post: 01-16-2020 10:45 AM
    by johnny4strings  Go to last post

    Forum:
    Excel General

  8. [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)
    • 251
    Last Post: 12-02-2019 05:47 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  9. 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)
    • 137
    Last Post: 11-19-2019 11:05 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Subtotal with index and match function

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

    Forum:
    Excel Formulas & Functions

  11. [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)
    • 176
    Last Post: 11-01-2019 11:44 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  13. [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)
    • 263
    Last Post: 08-20-2019 06:09 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [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)
    • 237
    Last Post: 08-19-2019 09:09 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Programming / VBA / Macros

  16. [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)
    • 225
    Last Post: 08-01-2019 11:05 AM
    by CAntosh  Go to last post

    Forum:
    Excel Formulas & Functions

  17. 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)
    • 135
    Last Post: 07-03-2019 07:11 PM
    by jason.b75  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [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
    • 213
    Last Post: 07-01-2019 12:46 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Index Match to closed Workbook

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

    Forum:
    Excel Formulas & Functions

  20. [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)
    • 322
    Last Post: 06-24-2019 10:37 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] VLOOKUP Function not working properly

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

    Forum:
    Excel Formulas & Functions

  22. 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
    • 123
    Last Post: 06-06-2019 12:55 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  23. 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)
    • 214
    Last Post: 05-15-2019 02:56 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Listing all matches from index/match search

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

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] VBA Index Match Odd Fault

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

    Forum:
    Excel Programming / VBA / Macros

  26. [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)
    • 266
    Last Post: 05-09-2019 10:14 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Transforming Data Set

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

    Forum:
    Excel Formulas & Functions

  28. [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)
    • 159
    Last Post: 03-22-2019 06:19 PM
    by Shruder  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [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)
    • 480
    Last Post: 03-22-2019 08:35 AM
    by Phil123456789  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Auto lookup of rate table excluding not applicable

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

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Index / Match with IF?

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  34. [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
    • 1,083
    Last Post: 01-17-2019 01:34 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1