how to return mulitple corresponding values

Why don't you send me your file so I can see what your trying to do!

Let me know how to contact you.

Biff

"Debi H" <DebiH.RemoveThis@discussions.microsoft.com> wrote in message
news:BB9D917C-7DE5-491C-8AB1-6746BCA6DAB2@microsoft.com...
> Do you have code to do this dynamic? and loop inside of another llop?
>
> "Biff" wrote:
>
>> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
>>
>> Use this:
>>
>> =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)-ROW(A$2)+1),ROWS($1:1)),5)
>>
>> > can I change $A$2:$A$15=$A$60 to look up a range?
>>
>> What do you mean?
>>
>> Biff
>>
>> "Debi H" <DebiH.RemoveThis@discussions.microsoft.com> wrote in message
>> news:FBB32FD3-988E-4880-884A-47292E533784@microsoft.com...
>> > One more question please....
>> >
>> > If the fromula:
>> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
>> >
>> > can I change $A$2:$A$15=$A$60 to look up a range?
>> >
>> >
>> > "Biff" wrote:
>> >
>> >> You're welcome!
>> >>
>> >> Biff
>> >>
>> >> "Debi H" <DebiH.RemoveThis@discussions.microsoft.com> wrote in message
>> >> news:4F4E1A11-934B-44CB-B284-45774695BA73@microsoft.com...
>> >> > That worked...thanks
>> >> >
>> >> > "Biff" wrote:
>> >> >
>> >> >> Type the formula then, instead of hitting ENTER like you normally
>> >> >> would,
>> >> >> hold down both the CTRL key AND the SHIFT key then hit ENTER. When
>> >> >> done
>> >> >> properly Excel will enclose the formula in squihhly braces { }. You
>> >> >> can't
>> >> >> just type these braces in, you MUST use the key combination to
>> >> >> produce
>> >> >> them.
>> >> >>
>> >> >> If you're still having problems I'll be glad to look at your file
>> >> >> and
>> >> >> see
>> >> >> if
>> >> >> I can figure it out. Just let me know how to contact you.
>> >> >>
>> >> >> Biff
>> >> >>
>> >> >> "Debi H" <DebiH.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> news:F4426697-D07A-46FE-9166-EB3CA9665853@microsoft.com...
>> >> >> > That still does not work for me. Am I missing something?
>> >> >> > I did the key stroke of (CTRL+SHIFT+ENTER) 1ST
>> >> >> > Entered the formula
>> >> >> > and I get the VALUE error
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > "Biff" wrote:
>> >> >> >
>> >> >> >> Hi!
>> >> >> >>
>> >> >> >> The basic formula is something like this:
>> >> >> >>
>> >> >> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
>> >> >> >>
>> >> >> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
>> >> >> >>
>> >> >> >> Then copy down.
>> >> >> >>
>> >> >> >> Where column A contains the lookup_value and column B contains
>> >> >> >> the
>> >> >> >> values
>> >> >> >> to
>> >> >> >> be returned.
>> >> >> >>
>> >> >> >> Need more specific details to offer a more robust suggestion.
>> >> >> >>
>> >> >> >> Biff
>> >> >> >>
>> >> >> >> "MetricsShiva" <MetricsShiva.RemoveThis@discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
>> >> >> >> >i want to look up a name that occurs several times in one
>> >> >> >> >column
>> >> >> >> >of a
>> >> >> >> > spreadsheet and return corresponding values from each row the
>> >> >> >> > name
>> >> >> >> > occurs
>> >> >> >> > on.
>> >> >> >> > Vlookup returns only one value. How can I get multiple
>> >> >> >> > values?
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

you can email me at dlhembree RemoveThis @yahoo.com this weekend or call my mobile
864-320-5503. I will sent you the file if you send me your email address.

"Biff" wrote:

> Why don't you send me your file so I can see what your trying to do!
>
> Let me know how to contact you.
>
> Biff
>
> "Debi H" <DebiH RemoveThis @discussions.microsoft.com> wrote in message
> news:BB9D917C-7DE5-491C-8AB1-6746BCA6DAB2@microsoft.com...
> > Do you have code to do this dynamic? and loop inside of another llop?
> >
> > "Biff" wrote:
> >
> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >>
> >> Use this:
> >>
> >> =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)-ROW(A$2)+1),ROWS($1:1)),5)
> >>
> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >>
> >> What do you mean?
> >>
> >> Biff
> >>
> >> "Debi H" <DebiH RemoveThis @discussions.microsoft.com> wrote in message
> >> news:FBB32FD3-988E-4880-884A-47292E533784@microsoft.com...
> >> > One more question please....
> >> >
> >> > If the fromula:
> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >> >
> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >> >
> >> >
> >> > "Biff" wrote:
> >> >
> >> >> You're welcome!
> >> >>
> >> >> Biff
> >> >>
> >> >> "Debi H" <DebiH RemoveThis @discussions.microsoft.com> wrote in message
> >> >> news:4F4E1A11-934B-44CB-B284-45774695BA73@microsoft.com...
> >> >> > That worked...thanks
> >> >> >
> >> >> > "Biff" wrote:
> >> >> >
> >> >> >> Type the formula then, instead of hitting ENTER like you normally
> >> >> >> would,
> >> >> >> hold down both the CTRL key AND the SHIFT key then hit ENTER. When
> >> >> >> done
> >> >> >> properly Excel will enclose the formula in squihhly braces { }. You
> >> >> >> can't
> >> >> >> just type these braces in, you MUST use the key combination to
> >> >> >> produce
> >> >> >> them.
> >> >> >>
> >> >> >> If you're still having problems I'll be glad to look at your file
> >> >> >> and
> >> >> >> see
> >> >> >> if
> >> >> >> I can figure it out. Just let me know how to contact you.
> >> >> >>
> >> >> >> Biff
> >> >> >>
> >> >> >> "Debi H" <DebiH RemoveThis @discussions.microsoft.com> wrote in message
> >> >> >> news:F4426697-D07A-46FE-9166-EB3CA9665853@microsoft.com...
> >> >> >> > That still does not work for me. Am I missing something?
> >> >> >> > I did the key stroke of (CTRL+SHIFT+ENTER) 1ST
> >> >> >> > Entered the formula
> >> >> >> > and I get the VALUE error
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > "Biff" wrote:
> >> >> >> >
> >> >> >> >> Hi!
> >> >> >> >>
> >> >> >> >> The basic formula is something like this:
> >> >> >> >>
> >> >> >> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
> >> >> >> >>
> >> >> >> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
> >> >> >> >>
> >> >> >> >> Then copy down.
> >> >> >> >>
> >> >> >> >> Where column A contains the lookup_value and column B contains
> >> >> >> >> the
> >> >> >> >> values
> >> >> >> >> to
> >> >> >> >> be returned.
> >> >> >> >>
> >> >> >> >> Need more specific details to offer a more robust suggestion.
> >> >> >> >>
> >> >> >> >> Biff
> >> >> >> >>
> >> >> >> >> "MetricsShiva" <MetricsShiva RemoveThis @discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
> >> >> >> >> >i want to look up a name that occurs several times in one
> >> >> >> >> >column
> >> >> >> >> >of a
> >> >> >> >> > spreadsheet and return corresponding values from each row the
> >> >> >> >> > name
> >> >> >> >> > occurs
> >> >> >> >> > on.
> >> >> >> >> > Vlookup returns only one value. How can I get multiple
> >> >> >> >> > values?
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

did you get the speadsheet I sent?

"Biff" wrote:

> Why don't you send me your file so I can see what your trying to do!
>
> Let me know how to contact you.
>
> Biff
>
> "Debi H" <DebiH.DeleteThis@discussions.microsoft.com> wrote in message
> news:BB9D917C-7DE5-491C-8AB1-6746BCA6DAB2@microsoft.com...
> > Do you have code to do this dynamic? and loop inside of another llop?
> >
> > "Biff" wrote:
> >
> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >>
> >> Use this:
> >>
> >> =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)-ROW(A$2)+1),ROWS($1:1)),5)
> >>
> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >>
> >> What do you mean?
> >>
> >> Biff
> >>
> >> "Debi H" <DebiH.DeleteThis@discussions.microsoft.com> wrote in message
> >> news:FBB32FD3-988E-4880-884A-47292E533784@microsoft.com...
> >> > One more question please....
> >> >
> >> > If the fromula:
> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >> >
> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >> >
> >> >
> >> > "Biff" wrote:
> >> >
> >> >> You're welcome!
> >> >>
> >> >> Biff
> >> >>
> >> >> "Debi H" <DebiH.DeleteThis@discussions.microsoft.com> wrote in message
> >> >> news:4F4E1A11-934B-44CB-B284-45774695BA73@microsoft.com...
> >> >> > That worked...thanks
> >> >> >
> >> >> > "Biff" wrote:
> >> >> >
> >> >> >> Type the formula then, instead of hitting ENTER like you normally
> >> >> >> would,
> >> >> >> hold down both the CTRL key AND the SHIFT key then hit ENTER. When
> >> >> >> done
> >> >> >> properly Excel will enclose the formula in squihhly braces { }. You
> >> >> >> can't
> >> >> >> just type these braces in, you MUST use the key combination to
> >> >> >> produce
> >> >> >> them.
> >> >> >>
> >> >> >> If you're still having problems I'll be glad to look at your file
> >> >> >> and
> >> >> >> see
> >> >> >> if
> >> >> >> I can figure it out. Just let me know how to contact you.
> >> >> >>
> >> >> >> Biff
> >> >> >>
> >> >> >> "Debi H" <DebiH.DeleteThis@discussions.microsoft.com> wrote in message
> >> >> >> news:F4426697-D07A-46FE-9166-EB3CA9665853@microsoft.com...
> >> >> >> > That still does not work for me. Am I missing something?
> >> >> >> > I did the key stroke of (CTRL+SHIFT+ENTER) 1ST
> >> >> >> > Entered the formula
> >> >> >> > and I get the VALUE error
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > "Biff" wrote:
> >> >> >> >
> >> >> >> >> Hi!
> >> >> >> >>
> >> >> >> >> The basic formula is something like this:
> >> >> >> >>
> >> >> >> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
> >> >> >> >>
> >> >> >> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
> >> >> >> >>
> >> >> >> >> Then copy down.
> >> >> >> >>
> >> >> >> >> Where column A contains the lookup_value and column B contains
> >> >> >> >> the
> >> >> >> >> values
> >> >> >> >> to
> >> >> >> >> be returned.
> >> >> >> >>
> >> >> >> >> Need more specific details to offer a more robust suggestion.
> >> >> >> >>
> >> >> >> >> Biff
> >> >> >> >>
> >> >> >> >> "MetricsShiva" <MetricsShiva.DeleteThis@discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
> >> >> >> >> >i want to look up a name that occurs several times in one
> >> >> >> >> >column
> >> >> >> >> >of a
> >> >> >> >> > spreadsheet and return corresponding values from each row the
> >> >> >> >> > name
> >> >> >> >> > occurs
> >> >> >> >> > on.
> >> >> >> >> > Vlookup returns only one value. How can I get multiple
> >> >> >> >> > values?
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

> did you get the speadsheet I sent?

Yes, I'll take a look at it tonight.

Biff

"Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
news:4CB9155A-FD70-487A-8A2E-FD6568093A5A@microsoft.com...
> did you get the speadsheet I sent?
>
> "Biff" wrote:
>
>> Why don't you send me your file so I can see what your trying to do!
>>
>> Let me know how to contact you.
>>
>> Biff
>>
>> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:BB9D917C-7DE5-491C-8AB1-6746BCA6DAB2@microsoft.com...
>> > Do you have code to do this dynamic? and loop inside of another llop?
>> >
>> > "Biff" wrote:
>> >
>> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
>> >>
>> >> Use this:
>> >>
>> >> =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)-ROW(A$2)+1),ROWS($1:1)),5)
>> >>
>> >> > can I change $A$2:$A$15=$A$60 to look up a range?
>> >>
>> >> What do you mean?
>> >>
>> >> Biff
>> >>
>> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> news:FBB32FD3-988E-4880-884A-47292E533784@microsoft.com...
>> >> > One more question please....
>> >> >
>> >> > If the fromula:
>> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
>> >> >
>> >> > can I change $A$2:$A$15=$A$60 to look up a range?
>> >> >
>> >> >
>> >> > "Biff" wrote:
>> >> >
>> >> >> You're welcome!
>> >> >>
>> >> >> Biff
>> >> >>
>> >> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> >> news:4F4E1A11-934B-44CB-B284-45774695BA73@microsoft.com...
>> >> >> > That worked...thanks
>> >> >> >
>> >> >> > "Biff" wrote:
>> >> >> >
>> >> >> >> Type the formula then, instead of hitting ENTER like you
>> >> >> >> normally
>> >> >> >> would,
>> >> >> >> hold down both the CTRL key AND the SHIFT key then hit ENTER.
>> >> >> >> When
>> >> >> >> done
>> >> >> >> properly Excel will enclose the formula in squihhly braces { }.
>> >> >> >> You
>> >> >> >> can't
>> >> >> >> just type these braces in, you MUST use the key combination to
>> >> >> >> produce
>> >> >> >> them.
>> >> >> >>
>> >> >> >> If you're still having problems I'll be glad to look at your
>> >> >> >> file
>> >> >> >> and
>> >> >> >> see
>> >> >> >> if
>> >> >> >> I can figure it out. Just let me know how to contact you.
>> >> >> >>
>> >> >> >> Biff
>> >> >> >>
>> >> >> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> >> >> news:F4426697-D07A-46FE-9166-EB3CA9665853@microsoft.com...
>> >> >> >> > That still does not work for me. Am I missing something?
>> >> >> >> > I did the key stroke of (CTRL+SHIFT+ENTER) 1ST
>> >> >> >> > Entered the formula
>> >> >> >> > and I get the VALUE error
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Biff" wrote:
>> >> >> >> >
>> >> >> >> >> Hi!
>> >> >> >> >>
>> >> >> >> >> The basic formula is something like this:
>> >> >> >> >>
>> >> >> >> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
>> >> >> >> >>
>> >> >> >> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
>> >> >> >> >>
>> >> >> >> >> Then copy down.
>> >> >> >> >>
>> >> >> >> >> Where column A contains the lookup_value and column B
>> >> >> >> >> contains
>> >> >> >> >> the
>> >> >> >> >> values
>> >> >> >> >> to
>> >> >> >> >> be returned.
>> >> >> >> >>
>> >> >> >> >> Need more specific details to offer a more robust suggestion.
>> >> >> >> >>
>> >> >> >> >> Biff
>> >> >> >> >>
>> >> >> >> >> "MetricsShiva" <MetricsShiva.TakeThisOut@discussions.microsoft.com> wrote
>> >> >> >> >> in
>> >> >> >> >> message
>> >> >> >> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
>> >> >> >> >> >i want to look up a name that occurs several times in one
>> >> >> >> >> >column
>> >> >> >> >> >of a
>> >> >> >> >> > spreadsheet and return corresponding values from each row
>> >> >> >> >> > the
>> >> >> >> >> > name
>> >> >> >> >> > occurs
>> >> >> >> >> > on.
>> >> >> >> >> > Vlookup returns only one value. How can I get multiple
>> >> >> >> >> > values?
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Thanks.. you can send it to dlhembree.TakeThisOut@yahoo.com if it is before 6am tomorrow
morning or to the bme email after 6am.

Thanks

"Biff" wrote:

> > did you get the speadsheet I sent?
>
> Yes, I'll take a look at it tonight.
>
> Biff
>
> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
> news:4CB9155A-FD70-487A-8A2E-FD6568093A5A@microsoft.com...
> > did you get the speadsheet I sent?
> >
> > "Biff" wrote:
> >
> >> Why don't you send me your file so I can see what your trying to do!
> >>
> >> Let me know how to contact you.
> >>
> >> Biff
> >>
> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
> >> news:BB9D917C-7DE5-491C-8AB1-6746BCA6DAB2@microsoft.com...
> >> > Do you have code to do this dynamic? and loop inside of another llop?
> >> >
> >> > "Biff" wrote:
> >> >
> >> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >> >>
> >> >> Use this:
> >> >>
> >> >> =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)-ROW(A$2)+1),ROWS($1:1)),5)
> >> >>
> >> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >> >>
> >> >> What do you mean?
> >> >>
> >> >> Biff
> >> >>
> >> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> news:FBB32FD3-988E-4880-884A-47292E533784@microsoft.com...
> >> >> > One more question please....
> >> >> >
> >> >> > If the fromula:
> >> >> > =INDEX($A2:$H15,SMALL(IF($A$2:$A$15=$A$60,ROW($A$2:$A$15)),ROW(1:1)),5)
> >> >> >
> >> >> > can I change $A$2:$A$15=$A$60 to look up a range?
> >> >> >
> >> >> >
> >> >> > "Biff" wrote:
> >> >> >
> >> >> >> You're welcome!
> >> >> >>
> >> >> >> Biff
> >> >> >>
> >> >> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> >> news:4F4E1A11-934B-44CB-B284-45774695BA73@microsoft.com...
> >> >> >> > That worked...thanks
> >> >> >> >
> >> >> >> > "Biff" wrote:
> >> >> >> >
> >> >> >> >> Type the formula then, instead of hitting ENTER like you
> >> >> >> >> normally
> >> >> >> >> would,
> >> >> >> >> hold down both the CTRL key AND the SHIFT key then hit ENTER.
> >> >> >> >> When
> >> >> >> >> done
> >> >> >> >> properly Excel will enclose the formula in squihhly braces { }.
> >> >> >> >> You
> >> >> >> >> can't
> >> >> >> >> just type these braces in, you MUST use the key combination to
> >> >> >> >> produce
> >> >> >> >> them.
> >> >> >> >>
> >> >> >> >> If you're still having problems I'll be glad to look at your
> >> >> >> >> file
> >> >> >> >> and
> >> >> >> >> see
> >> >> >> >> if
> >> >> >> >> I can figure it out. Just let me know how to contact you.
> >> >> >> >>
> >> >> >> >> Biff
> >> >> >> >>
> >> >> >> >> "Debi H" <DebiH.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> >> >> news:F4426697-D07A-46FE-9166-EB3CA9665853@microsoft.com...
> >> >> >> >> > That still does not work for me. Am I missing something?
> >> >> >> >> > I did the key stroke of (CTRL+SHIFT+ENTER) 1ST
> >> >> >> >> > Entered the formula
> >> >> >> >> > and I get the VALUE error
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > "Biff" wrote:
> >> >> >> >> >
> >> >> >> >> >> Hi!
> >> >> >> >> >>
> >> >> >> >> >> The basic formula is something like this:
> >> >> >> >> >>
> >> >> >> >> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
> >> >> >> >> >>
> >> >> >> >> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
> >> >> >> >> >>
> >> >> >> >> >> Then copy down.
> >> >> >> >> >>
> >> >> >> >> >> Where column A contains the lookup_value and column B
> >> >> >> >> >> contains
> >> >> >> >> >> the
> >> >> >> >> >> values
> >> >> >> >> >> to
> >> >> >> >> >> be returned.
> >> >> >> >> >>
> >> >> >> >> >> Need more specific details to offer a more robust suggestion.
> >> >> >> >> >>
> >> >> >> >> >> Biff
> >> >> >> >> >>
> >> >> >> >> >> "MetricsShiva" <MetricsShiva.TakeThisOut@discussions.microsoft.com> wrote
> >> >> >> >> >> in
> >> >> >> >> >> message
> >> >> >> >> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
> >> >> >> >> >> >i want to look up a name that occurs several times in one
> >> >> >> >> >> >column
> >> >> >> >> >> >of a
> >> >> >> >> >> > spreadsheet and return corresponding values from each row
> >> >> >> >> >> > the
> >> >> >> >> >> > name
> >> >> >> >> >> > occurs
> >> >> >> >> >> > on.
> >> >> >> >> >> > Vlookup returns only one value. How can I get multiple
> >> >> >> >> >> > values?
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Biff,

I'm using your formula:

=INDEX($B$1:$B$190,SMALL(IF($A$1:$A$190=$D$1,ROW($A$1:$A$190)),ROW(A1)))

My question is this: Can the ranges $B$1:$B$190 and A$1:$A$190 be named
ranges with variable amounts of data? I export data out of our accounting
and want to use the formula, but the number of data points changes. It seems
that the function only works if all the cells between $b$1 and $b$190 have
data. Am i missing something?

thanks in advance,

greg

"Biff" wrote:

> Hi!
>
> > this formula works if the sheet is sorted by the value i'm looking up and
> > if
> > there are no duplicates in the field I want returned.
>
> The sheet does not need to be sorted and it doesn't matter if there are dupe
> return values.
>
> Post the *EXACT* formula that you tried.
>
> >I then want to include this
> > in a weekly dashboard for the 50+ managers i'm monitoring.
> >have you got anything else?
>
> Pivot table or filter
>
> Biff
>
> "MetricsShiva" <MetricsShiva.RemoveThis@discussions.microsoft.com> wrote in message
> news:DAC4D500-E098-42F4-BE13-C8CCCCC92563@microsoft.com...
> > this formula works if the sheet is sorted by the value i'm looking up and
> > if
> > there are no duplicates in the field I want returned. Otherwise i get
> > either
> > incorrect values returned or errors..
> >
> > basically, i have a sheet listing jobs scheduled by managers. I want to
> > be
> > able to look up the manager's name and return a list of all the job's
> > scheduled and the dates they were scheduled on. I then want to include
> > this
> > in a weekly dashboard for the 50+ managers i'm monitoring.
> >
> > Thanks for the response, but have you got anything else?
> >
> >
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> The basic formula is something like this:
> >>
> >> Entered as an array using the key combo of CTRL,SHIFT,ENTER:
> >>
> >> =INDEX(B$1:B$10,SMALL(IF(A$1:A$10=lookup_value,ROW($1:$10)),ROW(1:1)))
> >>
> >> Then copy down.
> >>
> >> Where column A contains the lookup_value and column B contains the values
> >> to
> >> be returned.
> >>
> >> Need more specific details to offer a more robust suggestion.
> >>
> >> Biff
> >>
> >> "MetricsShiva" <MetricsShiva.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:7CB57B18-A2B0-43D2-A726-6650586A3B94@microsoft.com...
> >> >i want to look up a name that occurs several times in one column of a
> >> > spreadsheet and return corresponding values from each row the name
> >> > occurs
> >> > on.
> >> > Vlookup returns only one value. How can I get multiple values?
> >>
> >>
> >>
>
>
>