Search:

Tag: index

Page 1 of 44 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. How can I combine a VLOOKUP or an INDEX with an IF AND function for a calendar?

    Started by cheeseleweese‎, 01-13-2021 12:34 PM
    and + if, calendar, dynamic calendar, index, vlook up 1 Attachment(s)
    • 62
    Last Post: 01-13-2021 12:43 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Determine a Row/Column then Search it

    Started by jakegordon97‎, 01-12-2021 12:04 PM
    ifs, index, lookup, match, search 1 Attachment(s)
    • 77
    Last Post: 01-12-2021 12:34 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  3. transpose X matching headers X duplicate tables (multiple problems)

    Started by JPRICH16‎, 01-02-2021 06:04 PM
    index, table array, tranpose 4 Attachment(s)
    • 194
    Last Post: 01-03-2021 03:39 PM
    by belinda200  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Pulling data from one worksheet into another using a unique identifier cell

    Started by p44rker‎, 12-30-2020 10:45 AM
    index, match, vlookup 2 Attachment(s)
    • 116
    Last Post: 12-30-2020 12:11 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Formula returned value & displayed value are different

    Started by shir02‎, 12-20-2020 07:03 AM
    index, index & if, row 7 Attachment(s)
    • 1,202
    Last Post: 12-23-2020 10:27 PM
    by JeteMc  Go to last post

    Forum:
    Excel General

  6. Index hyperlinks to show workbook cell text

    Started by DoxlMayne‎, 12-14-2020 04:05 PM
    hyperlink code, index, texttodisplay, toc for a worksheet
    • 83
    Last Post: 12-14-2020 08:29 PM
    by AlphaFrog  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  7. [SOLVED] How to find the average top 5 values and average bottom 5 values + index

    Started by Luu4466‎, 12-14-2020 12:35 PM
    bottom, index, top 5 11 Attachment(s)
    • 3,259
    Last Post: 01-04-2021 09:03 AM
    by Luu4466  Go to last post

    Forum:
    Excel General

  8. [SOLVED] Count until criteria from right to left

    Started by _Dice_‎, 12-11-2020 03:25 PM
    count, index, match 1 Attachment(s)
    • 81
    Last Post: 12-11-2020 03:49 PM
    by _Dice_  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Create an advanced report to show average price per brand (sorted by country+ cat of item)

    Started by Luu4466‎, 12-11-2020 03:41 AM
    aggregate, average, index, sort 3 Attachment(s)
    • 212
    Last Post: 12-14-2020 05:52 AM
    by Keebellah  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] How to report the top 20 and bottom 20 of a data table? + report with 2 conditions

    Started by Luu4466‎, 12-10-2020 04:39 AM
    index, top 3 Attachment(s)
    • 132
    Last Post: 12-10-2020 07:18 AM
    by Luu4466  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Need vlookup on images from different table format

    Started by gk_analytics‎, 12-06-2020 07:22 AM
    image box, index, vlookup 1 Attachment(s)
    • 110
    Last Post: 12-06-2020 08:44 AM
    by davesexcel  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] How to return results of a top 5 lowest price, top 5 highest price and price difference?

    Started by Luu4466‎, 12-04-2020 11:53 AM
    column, index, match, vlook up 3 Attachment(s)
    • 128
    Last Post: 12-05-2020 05:29 AM
    by Luu4466  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Matching a substring, returning value from matched row but different column

    Started by kryssie.e‎, 12-04-2020 05:51 AM
    dynamic list, index, match, substring 3 Attachment(s)
    • 185
    Last Post: 12-10-2020 07:43 AM
    by kryssie.e  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Arrays, Index, Match on multiple rows

    Started by nelsonk‎, 11-17-2020 10:56 AM
    array, index, match 2 Attachment(s)
    • 142
    Last Post: 11-17-2020 03:20 PM
    by nelsonk  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] Retrieving missing values from a list

    Started by Peter Niklas‎, 11-17-2020 04:45 AM
    formula, index, list, match 3 Attachment(s)
    • 153
    Last Post: 11-17-2020 06:19 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  16. Returning a non-numerical value that matches another list

    Started by Peter Niklas‎, 11-15-2020 06:25 AM
    array, function, index, match 1 Attachment(s)
    • 104
    Last Post: 11-15-2020 06:52 AM
    by Phuocam  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Index Match with multiple results

    Started by Wizards‎, 11-12-2020 07:07 PM
    index, match, small 1 Attachment(s)
    • 145
    Last Post: 11-13-2020 01:38 AM
    by hrlngrv  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Lost in VLOOKUP, OFFSET, INDEX, etc...

    Started by JefferyK‎, 11-11-2020 07:17 AM
    index, offset, vlookup 3 Attachment(s)
    • 110
    Last Post: 11-11-2020 09:36 AM
    by JefferyK  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Get values from different sheets where different bits of data values match

    Started by neilosj‎, 11-10-2020 11:49 AM
    index, values, vlookup 1 Attachment(s)
    • 111
    Last Post: 11-11-2020 03:36 AM
    by neilosj  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] INDEX MATCH problem that needs to seach row ABOVE if result cell is blank.

    Started by iwanradius‎, 11-07-2020 09:31 AM
    excel, index, match 1 Attachment(s)
    • 181
    Last Post: 11-08-2020 12:43 PM
    by iwanradius  Go to last post

    Forum:
    Excel General

  21. [SOLVED] Nested function or VBA to create heat map of prices

    Started by Luu4466‎, 11-07-2020 06:25 AM
    absolute value, heat map, index, index & if, nested function 3 Attachment(s)
    • 239
    Last Post: 11-11-2020 09:13 AM
    by Luu4466  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  22. [SOLVED] Get highest value based on two columns

    Started by Rehman5000‎, 11-05-2020 12:37 PM
    aggregate, highest, index, lookup, match 2 Attachment(s)
    • 114
    Last Post: 11-05-2020 01:57 PM
    by Rehman5000  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Get the value of a column based on the value of another column

    Started by Rehman5000‎, 11-05-2020 04:16 AM
    columns, index, lookup, match, search
    • 161
    Last Post: 11-05-2020 11:53 PM
    by Rehman5000  Go to last post

    Forum:
    Excel Formulas & Functions

  24. INDEX/MATCH using multiple worksheets where index is aplhanumeric

    Started by USAOz‎, 11-03-2020 02:55 AM
    excel 2016, index, match 3 Attachment(s)
    • 343
    Last Post: 11-10-2020 06:03 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Index match formula problem

    Started by kapi98‎, 10-28-2020 12:11 AM
    excel, formula, index, index & match, match 1 Attachment(s)
    • 152
    Last Post: 10-28-2020 01:59 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Index match giving #N/A

    Started by Barking_Mad‎, 10-27-2020 08:20 AM
    #n/a, index, match 1 Attachment(s)
    • 137
    Last Post: 10-27-2020 11:16 AM
    by Barking_Mad  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Create array that skips cells

    Started by riedyp‎, 10-21-2020 02:22 PM
    array, index, match 1 Attachment(s)
    • 136
    Last Post: 10-22-2020 07:15 PM
    by Estevaoba  Go to last post

    Forum:
    Excel General

  28. how to use index formula to lookup from bottom to top?

    Started by sagarkarki69‎, 10-21-2020 02:56 AM
    index, index & match, lookup, match, vlook-up
    • 137
    Last Post: 10-21-2020 09:31 PM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Cell reference using INDEX

    Started by Jacolene‎, 10-19-2020 05:07 AM
    index 1 Attachment(s)
    • 2,787
    Last Post: 10-19-2020 02:36 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  30. INDEX MATCH over multiple criteria not working

    Started by clemetti‎, 10-15-2020 09:01 AM
    index, match
    • 102
    Last Post: 10-15-2020 10:56 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Struggling with a Lookup Problem

    Started by clairefromperth‎, 10-01-2020 11:39 AM
    array, dynamic, index, lookup, match 2 Attachment(s)
    • 168
    Last Post: 10-01-2020 10:45 PM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Sum of 2 criteria's in different sheet

    Started by hsouiri‎, 09-30-2020 06:34 PM
    index, match, sum - range of cells, sumif + match, vlookup 1 Attachment(s)
    • 151
    Last Post: 09-30-2020 11:37 PM
    by hsouiri  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Return Row of data based on 2 dates using

    Started by newcommer‎, 09-29-2020 07:04 AM
    date return, index, lists, return all matches, row and formulas 1 Attachment(s)
    • 179
    Last Post: 10-28-2020 11:58 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Index & Match Formula to Get Value

    Started by raviraval86‎, 09-17-2020 01:00 AM
    index, index + match, match, vlookup 2 Attachment(s)
    • 144
    Last Post: 09-17-2020 02:33 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Getting last row value with INDEX MATCH MATCH

    Started by Toalle‎, 09-16-2020 09:55 AM
    index, match 7 Attachment(s)
    • 503
    Last Post: 09-23-2020 05:49 AM
    by Toalle  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 1513
Page 1 of 44 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1