| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return mulitple corresponding values
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return mulitple corresponding 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return mulitple corresponding values
did you get the speadsheet I sent?
Yes, I'll take a look at it tonight. Biff "Debi H" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return mulitple corresponding values
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
| How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Hybrid Mode
