+ Reply to Thread
Results 1 to 3 of 3

Alternative to using an array in an Index or similar function?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Alternative to using an array in an Index or similar function?

    I need a formula to generate the index_num in a Choose formula. The Match function in cell E4 does the trick, but I would prefer to actually embed the five numbers in C4:C8 in the Match function instead of using an array. I suspect that’s not possible with the match function. Is there an alternative function that would accomplish this goal? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,705

    Re: Alternative to using an array in an Index or similar function?

    Try

    =MATCH($G$4,{111,112,211,212,400},0)

  3. #3
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Re: Alternative to using an array in an Index or similar function?

    Perfect - Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Alternative to INDEX MATCH Array Formula to Populate Teaching Groups?
    By AliGW in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2015, 01:58 PM
  2. VBA Alternative to array index match
    By Helgard25 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-14-2015, 09:01 AM
  3. NthMatch UDF as An Alternative to Array function...
    By Vikas_Gautam in forum Tips and Tutorials
    Replies: 27
    Last Post: 01-13-2015, 11:47 PM
  4. [SOLVED] Index Match Vlookup Array or Similar
    By djm601 in forum Excel General
    Replies: 3
    Last Post: 10-27-2014, 04:39 PM
  5. Alternative to using an array formula for {=LARGE(IF(... function
    By Rabiah in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 05-30-2014, 05:52 AM
  6. UDF Lookup function as an alternative to array functions & match/index
    By Andrew_Harris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2012, 09:34 PM
  7. [SOLVED] Non array alternative for percentile function
    By vandan_tanna in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2012, 11:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1