Thread: vlookup w/ more than one return value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default vlookup w/ more than one return value
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"amy" wrote in message
...
This was perfect! Thank you for your help!

"T. Valko" wrote:

Here's a small sample file that demonstrates 2 methods.

If the lookup values are random or, if the lookup values are grouped
together or sorted.

Sample file - lookup with multiple lookup values 19kb


http://cjoint.com/?ivesCzGGpk

--
Biff
Microsoft Excel MVP


"amy" wrote in message
...
Is there a way to do a vlookup and have it return all different values
instead if just the top most value?

Thank you,
amy





Reply With QuoteReply With Quote