multi-VLOOKUP From an Array in VBA

[orcas]

Hi there,

Thanks for checking my thread, any suggestions from you is highly welcome.

I am trying to do multiple VLOOKUPS on a single value and wondered if you could help with some ideas.

Assume that i have a 4x4 VBA array consisting of the following items:

Ball	Baby	300	Ben
Ball	Teddy Bear	20	Gill
Wallet	Triangle	4	Mary
Hammer	Glass Cup	790	Danny

I will like to search for Ball in the second column and then return a single vector of

Baby

Teddy Bear

I will appreciate any help you can offer on how best to approach this.


Many thanks.

[stanleydgrom]

orcas,

See if the below link will help you:

VLookUpMulti, reply #9.

VBA code for looking up data that has multiple matches.

By jindon.
http://www.mrexcel.com/forum/showthr...ight=muvlookup

[orcas]

That link is very helpful, thank you very much stanleydgrom!!!

[stanleydgrom]

orcas,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.