| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup w/ more than one return value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
Not with VLOOKUP, but you may be able to achieve this with SUMPRODUCT
- when you say return all different values, do you mean add them all up, return then on different rows, return a composite string made up of all the matching values separated by a space? More details please. Pete On Aug 21, 12:04 am, amy wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
hello!
i can't view the sample files, could you please re-attached.. thanks i'm currently using below formula to return the multiple values.. =INDEX($A$2:$B$99,SMALL(IF($A$2:$A$99=$A$103,ROW($ A$2:$A$99)),ROW(1:1)),2) When i drag the formulas downwards, the values will show. However if i drag the formulas across the row, it does not seem to wrk, any idea? -- nikko "T. Valko" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
I am also looking for solution for looking up multiple values. I am unable to
access this link & its not in English.. Can you post the sample file. Thanks & regards Rajula "T. Valko" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup w/ more than one return value
Explain what you want to do and be sure to include where the data is located
and where you want the results. -- Biff Microsoft Excel MVP "Rajula" wrote in message ... I am also looking for solution for looking up multiple values. I am unable to access this link & its not in English.. Can you post the sample file. Thanks & regards Rajula "T. Valko" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the row for a value I VLOOKUP? | Excel Worksheet Functions | |||
| VlookUp that does not return #N/A | Excel Worksheet Functions | |||
| Vlookup that does not return #N/A | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| VLookup Return Value | Excel Worksheet Functions | |||
Hybrid Mode
