Search:

Tag: match and index

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. Not Solved: Formula to match 1 or 2 columns and then from a random range upon matching

    Started by ecomkid‎, 11-09-2022 10:08 PM
    excel, formula and if statement, match and index, random cell value, vlook up problem 4 Attachment(s)
    • 726
    Last Post: 11-15-2022 10:24 PM
    by Crooza  Go to last post

    Forum:
    Excel Formulas & Functions

  2. VBA use Application.VLookup and Application.HLookup together

    Started by dEcenu‎, 11-01-2021 10:13 AM
    hlookup, index, match and index, vlookup
    • 457
    Last Post: 11-02-2021 04:38 AM
    by dEcenu  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  3. Finding closest index/match from LAT/LON without REPEATS

    Started by LBook‎, 05-27-2021 01:49 PM
    distance between points, duplicate controls, match and index, unique 1 Attachment(s)
    • 511
    Last Post: 06-14-2021 06:16 PM
    by LBook  Go to last post

    Forum:
    Excel Formulas & Functions

  4. VLOOKUP to return sum of cells?

    Started by leewoo5‎, 01-14-2021 01:41 PM
    match and index, vlookup 1 Attachment(s)
    • 317
    Last Post: 01-14-2021 01:59 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Formula to check range cell if match then check the cell value and return true or false

    Started by lazyserv‎, 03-13-2020 04:10 AM
    excel, formula, logic formula, match and index
    • 1,700
    Last Post: 03-14-2020 03:58 AM
    by lazyserv  Go to last post

    Forum:
    Excel General

  6. [SOLVED] Finding Closest Match For Rows

    Started by mjm1013‎, 01-28-2020 01:29 PM
    index & match, index and match, match, match & index, match and index 1 Attachment(s)
    • 494
    Last Post: 01-28-2020 04:13 PM
    by mjm1013  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Match and Index Help

    Started by 20did99‎, 12-15-2019 10:12 AM
    match and index
    • 1,128
    Last Post: 12-15-2019 11:21 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Index Match update data

    Started by AaruJaan‎, 10-26-2019 07:36 AM
    index formula, lookup and autocomplete, match and index 4 Attachment(s)
    • 421
    Last Post: 10-26-2019 08:06 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Index Match Match Help

    Started by d7882‎, 08-26-2019 10:51 AM
    index, match and index 1 Attachment(s)
    • 411
    Last Post: 08-26-2019 01:01 PM
    by d7882  Go to last post

    Forum:
    Excel Formulas & Functions

  10. how to find each set of number occur times?

    Started by eddie01001‎, 06-14-2019 08:43 AM
    ifelse, match and index, match arrays
    • 446
    Last Post: 06-15-2019 03:35 AM
    by jason.b75  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Match and index

    Started by RichPee‎, 07-23-2018 08:25 AM
    formula, match and index 2 Attachment(s)
    • 315
    Last Post: 07-23-2018 09:22 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  12. Copy lines from data to sheet based on cell value

    Started by Jamesraywebber85‎, 07-09-2018 11:02 AM
    data entry, match and index, tables 1 Attachment(s)
    • 424
    Last Post: 07-09-2018 03:42 PM
    by CRIMEDOG  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Index & Match to lookup value from another workbook

    Started by Jamesraywebber85‎, 04-21-2018 02:11 PM
    match and index, vlookup 1 Attachment(s)
    • 516
    Last Post: 04-23-2018 11:40 AM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Changing Array Formula

    Started by JPSIMMON‎, 01-10-2018 07:29 PM
    array formula, array formula's, index, index & match, match and index
    • 1,015
    Last Post: 01-11-2018 01:25 PM
    by JPSIMMON  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Function Help!! - Thank You - Performance Return

    Started by mgecaj91‎, 10-30-2017 05:08 PM
    compound interest, formula, match and index 2 Attachment(s)
    • 604
    Last Post: 10-31-2017 10:20 PM
    by Richard Buttrey  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] INDEX MATCH MATCH first non-blank value

    Started by K12345‎, 10-23-2017 04:45 AM
    index, match and index, non-blank 2 Attachment(s)
    • 1,660
    Last Post: 10-23-2017 09:04 AM
    by K12345  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Add to existing match index formula a formula that will leave cells blank

    Started by Hedy‎, 08-15-2017 12:31 PM
    blank cell, formula and functions, match and index 2 Attachment(s)
    • 676
    Last Post: 08-15-2017 02:34 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Index + Match not working :(

    Started by lOYvEpi6M87nEoIF0ul8‎, 08-10-2017 12:31 PM
    grade, index, match and index, score 3 Attachment(s)
    • 636
    Last Post: 08-10-2017 01:30 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Need formula(s) for Moving Totals to automatically update within that or another formula

    Started by DPKologie‎, 07-08-2017 10:31 PM
    match and index, moving totals, offset formula 1 Attachment(s)
    • 542
    Last Post: 07-15-2017 10:41 AM
    by Aardigspook  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Match Three Columns to Return a Value in another Column

    Started by MotorcycleGuy‎, 06-19-2017 07:18 PM
    match and index 2 Attachment(s)
    • 397
    Last Post: 06-19-2017 07:50 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  21. Formula Broken: Need to return Sheet3:C"Address" when Sheet3:C"Name" is in Sheet1:C"Name"

    Started by jbtucke2‎, 06-16-2017 06:16 PM
    isnumber search, match and index, wild cards 2 Attachment(s)
    • 522
    Last Post: 06-19-2017 11:36 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Help with If, Match, Index, and Randbetween all in one formula

    Started by shpaul‎, 05-31-2017 03:19 PM
    formula assistance, if function, match and index, randbetween 2 Attachment(s)
    • 3,023
    Last Post: 06-07-2017 10:30 AM
    by dflak  Go to last post

    Forum:
    Excel Formulas & Functions

  23. Return a the latest Valeu (TEXT) entered based on a criteria

    Started by asantos80‎, 04-05-2017 01:01 PM
    date, match and index, max, vlook up
    • 487
    Last Post: 04-05-2017 02:44 PM
    by Miskondukt  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Index Match Entire Workbooks

    Started by NardoBro‎, 02-28-2017 08:25 PM
    linked workbooks, linked worksheets, lookup, match and index 2 Attachment(s)
    • 5,716
    Last Post: 03-03-2017 11:32 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Gale Shapley matching (Stable Marriage problem)

    Started by tshobe‎, 08-05-2016 11:46 PM
    algorithm, logical function, match, match and index, match cell value 1 Attachment(s)
    • 11,092
    Last Post: 05-12-2019 04:38 AM
    by Richard Buttrey  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Insert Search (wildcard) in an index/match formula

    Started by ZedaG‎, 07-13-2016 07:35 AM
    match and index, search
    • 1,017
    Last Post: 07-13-2016 08:04 AM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  27. If a value is present in sheet 2, return a text

    Started by Creep222‎, 07-12-2016 01:56 AM
    match and index, vlookup
    • 619
    Last Post: 07-12-2016 04:14 AM
    by Special-K  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Return the new dates one time

    Started by mariur89‎, 05-05-2016 04:58 AM
    date array, match and index, matrix formula, return cell value 3 Attachment(s)
    • 1,451
    Last Post: 05-05-2016 11:49 AM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  29. INDEX MATCH formula, ignore blank cells and define time frames

    Started by ChildishAlbino‎, 02-15-2016 08:08 AM
    ignore blanks, match and index, threshold, timeframe 1 Attachment(s)
    • 1,337
    Last Post: 02-16-2016 03:16 PM
    by ChildishAlbino  Go to last post

    Forum:
    Excel General

  30. Finding a number in a multi-column array and returning the value from the leftmost column

    Started by shulomla‎, 02-01-2016 02:45 AM
    array, match and index 1 Attachment(s)
    • 953
    Last Post: 02-01-2016 03:49 AM
    by excelliot  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Attempting to allocate portions of the week randomly to colleagues

    Started by mrvp‎, 12-27-2015 02:08 PM
    match and index, randbetween random, random, vlookup 4 Attachment(s)
    • 878
    Last Post: 01-03-2016 10:20 AM
    by mrvp  Go to last post

    Forum:
    Excel General

  32. [SOLVED] INdex/Match Formula

    Started by gladston‎, 12-21-2015 12:05 PM
    index, index & match, index and match, match, match and index 2 Attachment(s)
    • 882
    Last Post: 12-28-2015 08:52 AM
    by gladston  Go to last post

    Forum:
    Excel General

  33. Email Address Matching in Two Worksheets

    Started by bisnamatchissues‎, 12-10-2015 11:49 AM
    email, iferror and match, isna, match and index, text match 2 Attachment(s)
    • 925
    Last Post: 12-10-2015 11:58 AM
    by bisnamatchissues  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Search multpile rows followed by a row search

    Started by Beach Walker‎, 12-07-2015 02:28 AM
    match and index 3 Attachment(s)
    • 861
    Last Post: 12-08-2015 06:49 AM
    by Jacc  Go to last post

    Forum:
    Excel General

  35. [SOLVED] Lookup formula for simple table - Returning position of item in transit

    Started by Santa1986‎, 09-25-2015 02:16 PM
    lookup formula, match and index, office 2007, offset 1 Attachment(s)
    • 685
    Last Post: 09-25-2015 04:39 PM
    by daffodil11  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 64
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1