Search:

Tag: index & match

Page 1 of 9 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

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

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Programming / VBA / Macros

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Index Match to closed Workbook

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] VLOOKUP Function not working properly

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  13. Listing all matches from index/match search

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

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] VBA Index Match Odd Fault

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

    Forum:
    Excel Programming / VBA / Macros

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

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] Transforming Data Set

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  19. Auto lookup of rate table excluding not applicable

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

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Index / Match with IF?

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  22. [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)
    • 335
    Last Post: 01-28-2019 09:52 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  25. Roster Days to Hours per Week?

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

    Forum:
    Excel Formulas & Functions

  26. 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)
    • 124
    Last Post: 12-14-2018 09:30 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  27. 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)
    • 264
    Last Post: 12-05-2018 03:13 AM
    by Keebellah  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  28. [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)
    • 224
    Last Post: 10-19-2018 11:39 AM
    by Stuepef  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Understanding a formula

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

    Forum:
    Excel Formulas & Functions

  30. [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)
    • 153
    Last Post: 10-10-2018 08:43 AM
    by ClickingNoise  Go to last post

    Forum:
    Excel Formulas & Functions

  31. 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
    • 114
    Last Post: 10-08-2018 10:29 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  32. [SOLVED] Index: Return Total Number of Items in a Range

    Started by orcaaccounting‎, 09-16-2018 04:09 PM
    index & match 6 Attachment(s)
    • 291
    Last Post: 09-19-2018 05:20 PM
    by orcaaccounting  Go to last post

    Forum:
    Excel Charting & Pivots

  33. Return a Metro City after matching a mailing city with a suburb

    Started by themole‎, 07-17-2018 11:24 PM
    array, index & match, macro, macro (vba), vba 1 Attachment(s)
    • 178
    Last Post: 07-18-2018 10:16 AM
    by themole  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Index Match

    Started by Wiggy74‎, 06-15-2018 11:27 AM
    index & match 2 Attachment(s)
    • 211
    Last Post: 06-29-2018 02:03 PM
    by JeteMc  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  35. INDIRECT last text value in range

    Started by jdcortez‎, 06-05-2018 11:45 PM
    index & match, indirect function, ref error
    • 235
    Last Post: 06-06-2018 12:33 AM
    by jdcortez  Go to last post

    Forum:
    Excel Formulas & Functions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1