Search:

Tag: index and match

Page 1 of 4 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Find data within a "dynamic" range

    Started by Carlalem‎, 12-12-2024 12:43 AM
    index and match 5 Attachment(s)
    • 462
    Last Post: 01-14-2025 07:56 AM
    by Carlalem  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Dynamic Range Dependent on Column Header

    Started by WaylettChris‎, 08-30-2024 11:41 AM
    dynamic range, forecast, index and match 2 Attachment(s)
    • 292
    Last Post: 08-30-2024 01:08 PM
    by WaylettChris  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Index only visible data

    Started by mamishgulu‎, 08-22-2024 04:37 AM
    excel #n/a, index and match, visible 3 Attachment(s)
    • 355
    Last Post: 08-22-2024 06:32 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Stuck with SUM using Index Match or Vlookup

    Started by mohdabrar‎, 11-16-2023 01:01 AM
    index and match, sum, vlookup 2 Attachment(s)
    • 485
    Last Post: 11-16-2023 02:32 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Combine functions to return the right values from a matrix

    Started by emsexcel‎, 10-30-2023 06:23 AM
    index & aggregate, index and match, index and small, other functions? 6 Attachment(s)
    • 482
    Last Post: 10-31-2023 05:29 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Additional layer to Index formula

    Started by Sorridere‎, 09-24-2023 09:22 AM
    index, index and match, index and match and if 2 Attachment(s)
    • 432
    Last Post: 09-25-2023 04:36 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Index and match not working

    Started by Ranbir‎, 07-28-2023 01:28 PM
    index and match 2 Attachment(s)
    • 492
    Last Post: 07-29-2023 08:31 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Combine SUMIFS INDEX MATCH and date range

    Started by TRF7‎, 07-12-2023 06:45 AM
    index and match, sumifs & dates, sumprodcut 2 Attachment(s)
    • 572
    Last Post: 07-12-2023 11:44 AM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Index and Multiple Match or ifCountIf formula

    Started by almavictory‎, 06-23-2023 08:09 PM
    count if, if formua, index and match, multiple match 2 Attachment(s)
    • 501
    Last Post: 06-28-2023 12:09 PM
    by almavictory  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] How to use a VLookup or a INDEX Match to return a value thats in random cells in column

    Started by Luiscarlos‎, 05-25-2023 07:20 AM
    formula, index and match, vlookup 1 Attachment(s)
    • 335
    Last Post: 05-25-2023 07:41 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Index Match from Two Columns - Issue

    Started by djc123‎, 03-18-2023 08:04 AM
    index and match 2 Attachment(s)
    • 347
    Last Post: 03-19-2023 03:18 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  12. Adjust array to column guided by cell value

    Started by arturoc‎, 12-01-2022 07:39 PM
    excel & array, formula array, index and match, lookup and match 2 Attachment(s)
    • 449
    Last Post: 12-02-2022 02:20 PM
    by Estevaoba  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Finding Unique Values Looking up and down

    Started by excel wannabe pp‎, 11-22-2022 10:28 PM
    index and match, max, mmult 1 Attachment(s)
    • 476
    Last Post: 11-25-2022 09:30 AM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Retrieve the hourly rate for the name of the person in the original cell for correct year

    Started by cooksley1‎, 11-09-2022 02:01 AM
    index and match, lookup 2 Attachment(s)
    • 639
    Last Post: 11-09-2022 07:27 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Macro to scan multiple columns and find total sum of each unique item on a list of unique

    Started by Oraekene‎, 09-24-2022 07:44 AM
    excel 2013, index and match, macro, sumif and index and match, vba 2 Attachment(s)
    • 468
    Last Post: 09-24-2022 08:11 AM
    by AliGW  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. [SOLVED] Index Match but excluding the first result

    Started by timbap‎, 08-08-2022 03:26 AM
    index, index & match, index + match, index and match 3 Attachment(s)
    • 901
    Last Post: 08-08-2022 07:43 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] VBA that does what an Index & Match does

    Started by rahul_ferns76‎, 07-20-2022 03:20 AM
    index and match 2 Attachment(s)
    • 565
    Last Post: 07-22-2022 04:28 AM
    by rahul_ferns76  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  18. Index and Match with Multiple Results

    Started by dandanrolando‎, 06-15-2022 08:11 AM
    index and match
    • 422
    Last Post: 06-15-2022 08:32 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  19. index/match previous value

    Started by abe914‎, 03-06-2022 05:49 PM
    index and match, index match lookup 1 Attachment(s)
    • 467
    Last Post: 03-06-2022 06:35 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Index Match function does not work with Textbox VBA

    Started by rad042‎, 11-05-2021 10:19 PM
    index and match, textbox, variable format, vba
    • 474
    Last Post: 11-05-2021 10:30 PM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  21. [SOLVED] Check data in a table array that changes

    Started by Baabaa‎, 10-17-2021 11:17 PM
    dynamic array, index and match
    • 419
    Last Post: 10-18-2021 05:34 AM
    by Baabaa  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Index Match and return mutiple results from a table

    Started by BassemCh‎, 09-23-2021 07:15 PM
    index and match 1 Attachment(s)
    • 449
    Last Post: 09-23-2021 07:20 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] how to lookup the words which is inside the sentence and using lookup formula to get data?

    Started by sagarkarki69‎, 07-22-2021 08:07 AM
    find, index and match, lookup and match, search 1 Attachment(s)
    • 518
    Last Post: 07-22-2021 08:52 AM
    by samba_ravi  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Run Time Error 1004- Long Array Formula in VBA (How to split the VBA code)

    Started by Shamis12‎, 06-27-2021 03:33 AM
    array formula, index and match, vba & excel
    • 808
    Last Post: 06-27-2021 12:13 PM
    by Vraag en antwoord  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  25. Customer Onboarding Schedule across months

    Started by ryanyvr‎, 03-23-2021 01:20 PM
    index and match 2 Attachment(s)
    • 535
    Last Post: 03-26-2021 08:17 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Capture data from multiple tabs and paste in specific format

    Started by d7882‎, 02-19-2021 12:01 PM
    index and match, transpose array 1 Attachment(s)
    • 470
    Last Post: 02-20-2021 04:09 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Identify all unique values in each row (dynamic data) and return the column header

    Started by nerdwannabe_‎, 01-26-2021 02:25 AM
    index & match, index and match, vlookup 1 Attachment(s)
    • 419
    Last Post: 01-26-2021 02:29 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Data Aggregations' with Index and Matich

    Started by CHICWS‎, 01-24-2021 02:08 PM
    consolidates report, index and match 3 Attachment(s)
    • 480
    Last Post: 01-24-2021 04:50 PM
    by Limor_OP  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] How to use MOD as a criteria in MAXIFS formula or any other solution to my problem

    Started by Govind0186‎, 12-13-2020 02:24 AM
    index and match, lookup & references, maxifs, mod, referencing 3 Attachment(s)
    • 1,258
    Last Post: 12-28-2020 12:47 PM
    by Govind0186  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] Look up Table and transpose to another

    Started by d7882‎, 12-02-2020 01:58 PM
    index and match, transpose, vlook up 2 Attachment(s)
    • 554
    Last Post: 12-02-2020 02:27 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] selecting second result while using index and match formula.

    Started by sagarkarki69‎, 11-23-2020 08:57 AM
    index and match 2 Attachment(s)
    • 525
    Last Post: 11-24-2020 01:05 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Index match - replace tab reference

    Started by bernard.x‎, 09-18-2020 12:27 AM
    different workbooks, index and match
    • 483
    Last Post: 09-18-2020 07:22 AM
    by Limor_OP  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] Index Match for Dynamically change in date rows based on each month

    Started by prasath17‎, 09-15-2020 11:15 PM
    iferror, index and match 1 Attachment(s)
    • 626
    Last Post: 09-17-2020 12:49 AM
    by Mrrrr  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Conditional Formatting conflicts based on date/time/room number and output a list

    Started by mollybop‎, 09-08-2020 02:38 AM
    conditional formatting, index and match, list
    • 1,495
    Last Post: 09-09-2020 01:18 AM
    by mollybop  Go to last post

    Forum:
    Outlook Formatting & Functions

  35. [SOLVED] Index and Match Function

    Started by Alan L 185‎, 08-28-2020 01:08 PM
    index and match 5 Attachment(s)
    • 526
    Last Post: 08-28-2020 10:41 PM
    by Alan L 185  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 124
Page 1 of 4 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1