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: