Results 1 to 6 of 6

Thread: MLookup not returning results

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Junior Member
    Join Date
    Jul 2011
    Posts
    19
    Rep Power
    0
    I've examined the code and can't discover where it differs from the code in the workbook. Can you pinpoint the difference for me?

    Putting "True" at the end, using the new code, works to fill the cells with the concatenated results, which is the same thing Rick Rothsteins LOOKUPCONCAT function does. However, I'm also interested in using MLookups ability to put each result in a different cell, using the formula like so:

    =MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q7))
    =MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q8))

    This works with the original MLookup macro on my working example, but neither option worked on the workbook I previously posted. Now with whatever change you made, the function to return concatenated results works, but returning only the 1st, 2nd, or Nth value doesn't work, instead it returns all results.

    See the updated workbook attached.
    Attached Files Attached Files

Similar Threads

  1. LookUp Value and Concatenate All Found Results
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 48
    Last Post: 10-31-2019, 07:00 AM
  2. MLookup:How to use
    By jomili in forum Excel Help
    Replies: 5
    Last Post: 01-16-2014, 11:05 PM
  3. VLOOKUP produces undesired results
    By Dimitrios Charalampidis in forum Excel Help
    Replies: 1
    Last Post: 02-15-2013, 11:32 PM
  4. Replies: 12
    Last Post: 05-27-2012, 08:38 PM
  5. VLOOKUP with Multiple Results
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-26-2011, 10:29 PM

Posting Permissions

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