MVLookup

Hi

Is there such a thing as MVlookup?  If so, what does it do?

Greg
greg_cAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
From the page:

The program works like VLOOKUP, but it is entered as an array formula and returns multiple values. The problem occurs, if the lookup value you are searching for only has 1 entry in the table array. MVLOOKUP will keep duplicating the results in all the cells you have selected for the formula.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
It is a custom function written by this guy:

   Title: Problem with MVLOOKUP
   Link: http://www.mrexcel.com/forum/showthread.php?t=57706

Kevin
0
 
Patrick MatthewsCommented:
greg_c,

Not in standard Excel.

In a Google search I came across some UDFs for MVlookup.  Here is one such example:

http://www.mrexcel.com/forum/showthread.php?t=18885#4

Works similarly to VLOOKUP, except that it retrieves multiple values back as an array.

Patrick
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Patrick MatthewsCommented:
slow fingers :)
0
 
barry houdiniCommented:
Or this one which I assume is an "April Fool"

regards, barry
0
 
greg_cAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.