Search:

Tag: index

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Can't get Index/Match to work correctly

    Started by USAOz, 2022-04-25 08:54 AM
    excel, index, match 2 Attachment(s)
    • Replies: 6
    • Views: 1,524
    Last Post: 2022-04-30 09:53 AM
    by AliGW  Go to last post

    Forum:
    Formulas

  2. Index-Match Error 1

    Started by USAOz, 2022-04-30 06:23 AM
    excel, excel formula, index, match 1 Attachment(s)
    • Replies: 1
    • Views: 274
    Last Post: 2022-04-30 06:43 AM
    by AliGW  Go to last post

    Forum:
    Formulas

  3. Change INDEX MATCH Function to UNIQUE FILTER for sorting data

    Started by tpampalone, 2021-02-24 09:59 PM
    filter, index, match, unique
    • Replies: 1
    • Views: 1,825
    Last Post: 2021-02-28 09:20 AM
    by AliGW  Go to last post

    Forum:
    Formulas

  4. Incrementing index on multiple categories - Power Query M

    Started by olabodeoa, 2021-02-10 01:39 AM
    incremental, index, power query
    • Replies: 6
    • Views: 3,717
    Last Post: 2021-02-11 03:05 PM
    by olabodeoa  Go to last post

    Forum:
    Power Query (Get & Transform) & M code

  5. Display a list of columns if data is present within?

    Started by ExcelHelpNecessary, 2021-01-19 08:21 PM
    excel, index, lookup, vba, vlookup 4 Attachment(s)
    • Replies: 6
    • Views: 3,449
    Last Post: 2021-01-28 05:12 PM
    by p45cal  Go to last post

    Forum:
    Other General Questions

  6. Formula for index match if two different lengths

    Started by excelnewbie12345, 2021-01-24 05:58 PM
    index, match formula issue 1 Attachment(s)
    • Replies: 2
    • Views: 1,530
    Last Post: 2021-01-24 08:15 PM
    by Bob Phillips  Go to last post

    Forum:
    Formulas

  7. INDEX/MATCH using multiple worksheets with alphanumeric index value

    Started by USAOz, 2020-11-03 08:11 AM
    excel, index, match 1 Attachment(s)
    • Replies: 1
    • Views: 1,489
    Last Post: 2020-11-06 11:01 AM
    by alansidman  Go to last post

    Forum:
    Formulas

  8. Index Results Help

    Started by radicalrom, 2019-01-04 05:49 PM
    column, excel, index
    • Replies: 4
    • Views: 2,621
    Last Post: 2019-01-05 09:46 AM
    by Pecoflyer  Go to last post

    Forum:
    Formulas

  9. Having problem with an index match formula

    Started by Nutsy, 2018-12-27 06:19 PM
    index, match 2 Attachment(s)
    • Replies: 6
    • Views: 2,751
    Last Post: 2018-12-28 03:07 PM
    by navic  Go to last post

    Forum:
    Formulas

  10. sum values based off matches from two ranges

    Started by Bl4ckPantha, 2018-11-01 07:56 AM
    index, match, sumif, sumifs, sumproduct 3 Attachment(s)
    • Replies: 9
    • Views: 6,212
    Last Post: 2018-11-10 05:40 PM
    by ajko7  Go to last post

    Forum:
    Formulas

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

    Started by JonnyBravo, 2018-09-28 05:03 PM
    index, match, sumif, sumproduct, vlookup
    • Replies: 3
    • Views: 3,284
    Last Post: 2018-09-28 06:58 PM
    by JonnyBravo  Go to last post

    Forum:
    Formulas

  12. Link to a dynamic file reference in closed workbook

    Started by drybsmt, 2018-07-06 05:56 PM
    index, indirect
    • Replies: 0
    • Views: 1,535
    Last Post: 2018-07-06 05:56 PM
    by drybsmt  Go to last post

    Forum:
    Formulas

  13. Power Query and VLOOKUP or INDEX//MATCH

    Started by KingJulian, 2018-06-08 12:02 AM
    external connections, index, power query, vlookup
    • Replies: 5
    • Views: 5,996
    Last Post: 2018-06-11 02:09 AM
    by NormS  Go to last post

    Forum:
    Other General Questions

  14. MODE Formula based off an array using a lookup

    Started by Bl4ckPantha, 2018-06-01 03:27 AM
    index, match, mode 1 Attachment(s)
    • Replies: 1
    • Views: 2,740
    Last Post: 2018-06-01 12:49 PM
    by NBVC  Go to last post

    Forum:
    Formulas

  15. Count of Pivot Column Data determined from a HLOOKUP?

    Started by Bl4ckPantha, 2018-05-23 01:31 AM
    countif, hlookup, index, match, sumif 1 Attachment(s)
    • Replies: 2
    • Views: 2,208
    Last Post: 2018-05-24 08:03 AM
    by Bl4ckPantha  Go to last post

    Forum:
    Formulas

  16. Combining INDEX, SMALL and ROW functions... incorrectly?

    Started by zredbaron, 2018-05-23 12:58 AM
    and formula, formula, index, row, small 1 Attachment(s)
    • Replies: 2
    • Views: 1,916
    Last Post: 2018-05-23 02:17 PM
    by zredbaron  Go to last post

    Forum:
    Formulas

  17. 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 1 Attachment(s)
    • Replies: 4
    • Views: 3,598
    Last Post: 2018-02-08 11:53 PM
    by rosetc16  Go to last post

    Forum:
    Formulas

  18. PLEASE HELP: Formula to Pull Information in Order (Example Attached)

    Started by rosetc16, 2018-01-23 09:35 PM
    excel, formula, function, help with formula, index 2 Attachment(s)
    • Replies: 6
    • Views: 3,529
    Last Post: 2018-01-24 07:32 PM
    by NBVC  Go to last post

    Forum:
    Formulas

  19. Dynamic Sub-tables from Master - COUNTIF, IF, SMALL, INDEX, ROW, ROWS

    Started by SamB-R, 2017-10-02 04:51 PM
    countif, formula sum if, index, small, sub tables
    • Replies: 1
    • Views: 2,050
    Last Post: 2017-10-02 05:10 PM
    by AliGW  Go to last post

    Forum:
    Formulas

  20. Finding a value with horizontal and vertical parameters

    Started by willian2142, 2017-08-28 03:34 PM
    corresp, find, index, proc, table
    • Replies: 1
    • Views: 2,411
    Last Post: 2017-08-28 07:52 PM
    by NBVC  Go to last post

    Forum:
    Formulas

  21. Return value, INDEX MATCH

    Started by nesheim, 2017-05-19 03:35 PM
    index, index match, match 1 Attachment(s)
    • Replies: 2
    • Views: 2,352
    Last Post: 2017-05-19 05:10 PM
    by nesheim  Go to last post

    Forum:
    Formulas

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

    Started by rosetc16, 2017-04-22 01:28 AM
    excel, if function, index, index match, match
    • Replies: 1
    • Views: 2,357
    Last Post: 2017-04-22 06:22 AM
    by AliGW  Go to last post

    Forum:
    Formulas

  23. Using ISNUMBER SEARCH with INDEX MATCH

    Started by Emile, 2017-03-21 10:54 AM
    index, isnumber, match, search
    • Replies: 5
    • Views: 6,205
    Last Post: 2017-03-21 06:18 PM
    by NBVC  Go to last post

    Forum:
    Formulas

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

    Started by bilegt, 2017-01-24 05:18 AM
    hplookup, index, match, table, vlookup 5 Attachment(s)
    • Replies: 4
    • Views: 3,224
    Last Post: 2017-01-24 03:56 PM
    by Canapone  Go to last post

    Forum:
    Formulas

  25. 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 5 Attachment(s)
    • Replies: 6
    • Views: 4,421
    Last Post: 2016-11-22 12:03 AM
    by adamdeeakaaj  Go to last post

    Forum:
    Formulas

Results 1 to 25 of 54
Page 1 of 3 1 2 3
Gravatar by 1e2.it