PDA

View Full Version : [SOLVED] multi-VLOOKUP From an Array in VBA



orcas
07-30-2013, 03:51 AM
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
08-03-2013, 04:57 AM
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/showthread.php?t=344561&highlight=muvlookup

orcas
08-04-2013, 01:24 AM
That link is very helpful, thank you very much stanleydgrom!!!

stanleydgrom
08-04-2013, 10:27 AM
orcas,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.