Search:

Tag: index and match function

Search: Replies Views Search took 0.00 seconds.

  1. Pivot table: matching item name from another sheet and showing unit price with pivot table

    Started by Hasnat124‎, 06-07-2023 12:24 AM
    getpivotdata, index and match function, pivot table 2016 2 Attachment(s)
    • 327
    Last Post: 06-07-2023 05:50 AM
    by sandy666  Go to last post

    Forum:
    Excel Charting & Pivots

  2. Advanced Index Match maybe ??

    Started by SAKVoith‎, 05-13-2023 03:23 PM
    index and match function 1 Attachment(s)
    • 309
    Last Post: 09-01-2023 09:01 AM
    by SAKVoith  Go to last post

    Forum:
    Excel General

  3. [SOLVED] Index & Match from two worksheets.

    Started by J2022‎, 04-13-2022 06:30 AM
    index and match function 2 Attachment(s)
    • 397
    Last Post: 04-15-2022 09:55 AM
    by J2022  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Index and Match Employee ID

    Started by bob112233‎, 03-25-2022 03:13 AM
    index and match function, lookup, xlookup 1 Attachment(s)
    • 711
    Last Post: 03-25-2022 03:43 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] help with index and match that returns value based on multiple criteria

    Started by miggysantini‎, 09-27-2021 06:59 PM
    index and match function, lookups 3 Attachment(s)
    • 377
    Last Post: 09-29-2021 11:41 AM
    by GeoffW283  Go to last post

    Forum:
    Excel Formulas & Functions

  6. 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)
    • 720
    Last Post: 08-06-2020 03:42 AM
    by Haseeb Avarakkan  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Multi partial match conditions across two sheets

    Started by JoZ_813‎, 04-09-2020 07:53 PM
    index and match function, multiple conditions, partial matches, vba 1 Attachment(s)
    • 475
    Last Post: 04-13-2020 03:26 PM
    by dangelor  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  8. [SOLVED] Flag up purchases made when the card was in a different location to associated vehicle

    Started by ProblemSolver‎, 04-08-2020 11:42 AM
    index and match and if, index and match function, look up function, time and date formulas, vlook up problem 4 Attachment(s)
    • 687
    Last Post: 04-20-2020 09:45 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  9. [SOLVED] Return the header of the table based on the data in array

    Started by ronakpatel‎, 10-27-2019 01:10 PM
    formula, index and match function, lookup 1 Attachment(s)
    • 370
    Last Post: 10-27-2019 06:21 PM
    by ronakpatel  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Multiple Indexing/Matching and picking the Maximum Retrieved Value

    Started by JPSIMMON‎, 10-01-2019 12:55 PM
    index, index + match, index and match and if, index and match function, match & index
    • 474
    Last Post: 10-01-2019 09:10 PM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Multiple references in one formula. Tried SUMIF, VLOOKUP, INDEX, and MATCH.

    Started by lazers26‎, 07-23-2019 05:37 PM
    index and match function, sumif and index and match, vlookup + index + match 2 Attachment(s)
    • 398
    Last Post: 07-24-2019 10:23 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] If two criteria place in third criteria column

    Started by aabr‎, 07-19-2019 10:16 AM
    criteria as text, criteria mutliple columns, index and match function, three conditions 5 Attachment(s)
    • 479
    Last Post: 09-16-2019 12:11 PM
    by aabr  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Ranking and Sorting Alphanumeric Data for Top 10 list

    Started by uknusa‎, 06-29-2019 09:54 AM
    alphanumeric, index and match function, max function, top 10 4 Attachment(s)
    • 910
    Last Post: 06-29-2019 11:38 PM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Dynamic Index Match formula using named ranges

    Started by cross1‎, 06-11-2019 01:00 PM
    dynamic, index and match function, indirect, named range, reference a cell 2 Attachment(s)
    • 1,347
    Last Post: 06-17-2019 06:18 PM
    by protonLeah  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Two way lookup with dynamic shift of start point

    Started by atongaonkar‎, 06-07-2019 08:14 AM
    index and match function, two column lookup 1 Attachment(s)
    • 658
    Last Post: 06-08-2019 02:13 PM
    by atongaonkar  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] Conditional Multiple Criteria Lookup to Find Rows to Keep

    Started by akblack‎, 11-09-2018 01:39 PM
    index and match function, max, multiple array look up, vlook 1 Attachment(s)
    • 445
    Last Post: 11-09-2018 03:21 PM
    by 63falcondude  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Lookup Value from two sheets by dates

    Started by chandramouliarun‎, 09-27-2018 02:22 PM
    excel, function, index and match function, lookup and match 1 Attachment(s)
    • 488
    Last Post: 09-28-2018 01:34 AM
    by Bo_Ry  Go to last post

    Forum:
    Excel General

  18. [SOLVED] Pull data from other tab - vlook? indexmatchmatch?

    Started by d7882‎, 06-25-2018 02:01 PM
    index and match function, vlookup 1 Attachment(s)
    • 385
    Last Post: 06-25-2018 02:48 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Index match to sum multiple match columns

    Started by rosboy‎, 04-17-2018 06:03 PM
    index and match function, sum 2 Attachment(s)
    • 654
    Last Post: 04-18-2018 04:14 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Using two tables to arrive at the correct number

    Started by darbar76528‎, 02-03-2018 11:37 PM
    index and match function, multiple tables 2 Attachment(s)
    • 519
    Last Post: 02-04-2018 01:43 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] INDEX MATCH MIN Formula

    Started by koorn1992‎, 09-13-2017 09:11 AM
    excel, formula aggregation, index and match function, min function 1 Attachment(s)
    • 686
    Last Post: 09-13-2017 10:33 AM
    by koorn1992  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Is it possible to use an array as MATCH criteria?

    Started by oCoCarbon‎, 04-28-2017 04:12 AM
    array formula, index and match function
    • 556
    Last Post: 04-28-2017 01:59 PM
    by FlameRetired  Go to last post

    Forum:
    Excel General

  23. [SOLVED] Multiple Index Match on different sheets How?

    Started by thorrrr‎, 01-27-2017 01:25 PM
    index and match function 2 Attachment(s)
    • 1,743
    Last Post: 02-01-2017 09:55 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  24. Conditional Formatting with a INDEX(MATCH) array formula

    Started by bdaboy22‎, 12-15-2016 12:43 PM
    conditional formatting, index and match function 2 Attachment(s)
    • 2,869
    Last Post: 12-18-2016 08:57 AM
    by southward  Go to last post

    Forum:
    Excel General

  25. [SOLVED] INDEX/MATCH error cannot be explained

    Started by lsargent‎, 10-28-2016 07:20 PM
    index & match, index + match, index and match, index and match function
    • 3,914
    Last Post: 01-05-2017 07:07 PM
    by lsargent  Go to last post

    Forum:
    Excel Formulas & Functions

  26. top 3 and last 3 values in a table should return row headers concatenate with comma

    Started by anchuri_chaitanya‎, 09-12-2016 06:11 AM
    excel, functions and formula, index and match function, large, small 5 Attachment(s)
    • 1,365
    Last Post: 09-12-2016 07:44 PM
    by sanram  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Rows to Columns Transpose Error

    Started by Excell1677‎, 08-14-2016 12:39 AM
    index and match function, small function, transpose 1 Attachment(s)
    • 730
    Last Post: 08-14-2016 02:48 AM
    by Excell1677  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Student info (need help)

    Started by kashifshahzad‎, 07-23-2016 08:47 AM
    index and match function 2 Attachment(s)
    • 670
    Last Post: 07-23-2016 09:28 AM
    by southward  Go to last post

    Forum:
    Excel General

  29. Index and Match Function

    Started by Eric Tsang‎, 05-28-2016 12:18 PM
    index and match function 1 Attachment(s)
    • 476
    Last Post: 05-28-2016 12:49 PM
    by zbor  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] Formula for finding Start, Stop, Highest and Lowest value

    Started by mariur89‎, 05-05-2016 05:33 AM
    index and match function, look up data, matrix formula, max in range 2 Attachment(s)
    • 848
    Last Post: 05-05-2016 06:07 AM
    by José Augusto  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Returns a single result based on multiple criteria

    Started by Humanoj‎, 04-27-2016 11:32 AM
    index and match function, mulitple criteria, single value 2 Attachment(s)
    • 1,312
    Last Post: 04-29-2016 10:22 AM
    by Humanoj  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Help ! SUMIFS with 4 conditions and massive data - Fast and Light alternatives required

    Started by dan_dub‎, 04-22-2016 09:56 AM
    index and match function, sumifs, table
    • 825
    Last Post: 04-22-2016 10:44 AM
    by FoxSeaLady  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Match and Index function

    Started by Eric Tsang‎, 02-04-2016 11:38 AM
    index and match function 1 Attachment(s)
    • 532
    Last Post: 02-04-2016 11:48 AM
    by Gatti  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 33 of 33

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1