MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP, can I get more than one result?


Posted by Keith on August 23, 2001 9:12 AM

When using VLOOKUP, can I get it to return values for all lookup_values that are close to what's input? Like, if the lookup_value was "Smith," can it return all Smiths, or, if not, is there a way to add another VLOOKUP that wouldn't consider the first "Smith" that was found?

Here's how I have it set-up right now, but this only returns the first instance of the value in C4:

=VLOOKUP(C4,DataSheet!B2:F1141,1)

Thanks!
Keith


Posted by Barrie Davidson on August 23, 2001 9:21 AM

Unfortunately you can't. Can you...?

Can you use data filtering and then cut & paste filtered data?

Barrie

Posted by Keith on August 23, 2001 9:40 AM

If that's possible...I don't know how...

I'd love to be able to have the user's input automatically activate an advanced filter and have the results cut and pasted to a field for display (that seems the most intuitive), but I have no clue where to even begin on that! :-)

Posted by Barrie Davidson on August 23, 2001 9:48 AM

Re: If that's possible...I don't know how...

Keith, I've written a macro that can do this. Bad news is that it is at home. When I get home tonight I'll e-mail you the code and provide an explanation on how to use it (about 7 hours from now).

Barrie

Posted by Keith on August 23, 2001 10:04 AM

Wow, Barrie, thank you!


Barrie, thank you very much!

~Keith

Posted by Wiz on August 27, 2001 1:46 AM

Barrie, May I have your macro?

Thanks in advance.

Posted by Barrie Davidson on August 27, 2001 11:16 AM

Re: Barrie, May I have your macro?

Wiz, I'll try to send it to you tonight.

Barrie