Results 1 to 8 of 8

Problem with Index, Small, Array to return multiple values for single look up value,

Threaded View

  1. 10-10-2014, 04:07 PM #1
    JO505
    JO505 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Problem with Index, Small, Array to return multiple values for single look up value,

    In the attached file I am having a problem picking up the proper values. It seems to work for the first value but does not copy down correctly.

    Jim O
    Attached Files Attached Files
    Last edited by JO505; 10-10-2014 at 05:07 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to return multiple values from an array in a single cell?
    By fkalinx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2014, 04:16 AM
  2. Return values from multiple rows (with unique identifier) into single row - Arrays/Index?
    By nickjcam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 09:45 PM
  3. [SOLVED] Dependent Dropdown List Using Index and Small Won't Return Multiple Values
    By ebevis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2013, 02:28 AM
  4. return multiple matches using INDEX and SMALL
    By merlyn45 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2013, 05:14 AM
  5. Using Index & Small to return multiple values
    By BHudPE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2010, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1