Look up one value in a range and return multiple corresponding values

[faizumarali]

Lookup value is in k2 and range is A2:A23

If k2 = A2:A23 I would like to find out multiple values in the range G2:G23 in column L (result mulitple occurance would be Vertically or Horizontally) by using Ctrl + shift + enter

 

[faizumarali]

Please help me on the above case

 

[Aladin Akyurek]

Lookup value is in k2 and range is A2:A23

If k2 = A2:A23 I would like to find out multiple values in the range G2:G23 in column L (result mulitple occurance would be Vertically or Horizontally) by using Ctrl + shift + enter

Please help me on the above case

Adapt one that is appropriate:

http://www.mrexcel.com/forum/excel-questions/231882-vlookup-return-all-matches.html#post1133916
http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354 (Post #3)