Lookup multiple values in table

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

I have a list that contains the letters in the left
column, and text values in the right column. Is there a
formula that will find all the matching letters and return
a string of all the corresponding text values?

e.g.
d=dog
f=fred
d=dove
g=get
d=dig
for the letter d, the return value is dog,dove,dig

TIA
 
Hi
For a formula approach: As VLOOKUP only return ONE match you'll
probably need VBA for this. One way
- download Alan Beban's array functions (http://home.pacbell.net/beban)
They'll include a function called VLOOKUPS (for returning multiple
lookup results)
- download the free add-in Morefunc.xll as you want to combine the
results in one cell
(http://longre.free.fr/english/)

Now use the following formula:
Assumption: column E contains your names
=MCONCAT(VLOOKUPS("d",$A$1:$B$100,2,0),",")
 
Back
Top