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.
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.