Search:

Tag: index and match

Page 1 of 4 1 2 3 4

Search: Replies Views Search took 0.00 seconds.

  1. [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)
    • 229
    Last Post: 11-16-2023 02:32 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [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)
    • 335
    Last Post: 10-31-2023 05:29 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [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)
    • 250
    Last Post: 09-25-2023 04:36 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Index and match not working

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

    Forum:
    Excel Formulas & Functions

  5. [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)
    • 308
    Last Post: 07-12-2023 11:44 AM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  6. 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)
    • 391
    Last Post: 06-28-2023 12:09 PM
    by almavictory  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [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)
    • 196
    Last Post: 05-25-2023 07:41 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Index Match from Two Columns - Issue

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

    Forum:
    Excel Formulas & Functions

  9. 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)
    • 271
    Last Post: 12-02-2022 02:20 PM
    by Estevaoba  Go to last post

    Forum:
    Excel Formulas & Functions

  10. 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)
    • 265
    Last Post: 11-25-2022 09:30 AM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [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)
    • 410
    Last Post: 11-09-2022 07:27 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  12. 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)
    • 351
    Last Post: 09-24-2022 08:11 AM
    by AliGW  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  13. [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)
    • 581
    Last Post: 08-08-2022 07:43 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [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)
    • 431
    Last Post: 07-22-2022 04:28 AM
    by rahul_ferns76  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  15. Index and Match with Multiple Results

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

    Forum:
    Excel Formulas & Functions

  16. index/match previous value

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

    Forum:
    Excel Formulas & Functions

  17. 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
    • 298
    Last Post: 11-05-2021 10:30 PM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

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

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

    Forum:
    Excel Formulas & Functions

  19. Index Match and return mutiple results from a table

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

    Forum:
    Excel Formulas & Functions

  20. [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)
    • 397
    Last Post: 07-22-2021 08:52 AM
    by samba_ravi  Go to last post

    Forum:
    Excel Formulas & Functions

  21. 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
    • 592
    Last Post: 06-27-2021 12:13 PM
    by Vraag en antwoord  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  22. Customer Onboarding Schedule across months

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

    Forum:
    Excel Formulas & Functions

  23. 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)
    • 319
    Last Post: 02-20-2021 04:09 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  24. 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)
    • 293
    Last Post: 01-26-2021 02:29 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Data Aggregations' with Index and Matich

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

    Forum:
    Excel Formulas & Functions

  26. [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)
    • 942
    Last Post: 12-28-2020 12:47 PM
    by Govind0186  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [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)
    • 441
    Last Post: 12-02-2020 02:27 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [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)
    • 401
    Last Post: 11-24-2020 01:05 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Index match - replace tab reference

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

    Forum:
    Excel Formulas & Functions

  30. [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)
    • 495
    Last Post: 09-17-2020 12:49 AM
    by Mrrrr  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [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,342
    Last Post: 09-09-2020 01:18 AM
    by mollybop  Go to last post

    Forum:
    Outlook Formatting & Functions

  32. [SOLVED] Index and Match Function

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

    Forum:
    Excel Formulas & Functions

  33. Index and Match on multiple similar tables

    Started by infinia‎, 08-06-2020 02:43 AM
    excel, index & match, index + match, index and match, index and match function 3 Attachment(s)
    • 716
    Last Post: 08-06-2020 03:42 AM
    by Haseeb Avarakkan  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Does INDEX and MATCH have to use arrays sorted in a particular order?

    Started by jrtaylor‎, 06-20-2020 01:34 PM
    index and match, sorting 1 Attachment(s)
    • 417
    Last Post: 06-20-2020 05:01 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Any alternatives to SUMIFS and COUNTIFS to speed up a workbook's calc time?

    Started by jrtaylor‎, 04-21-2020 01:40 PM
    countifs, index and match, slow calculations, sumifs 2 Attachment(s)
    • 1,101
    Last Post: 04-21-2020 02:55 PM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1