ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Returning multiple values from a list (https://www.excelbanter.com/excel-discussion-misc-queries/153407-returning-multiple-values-list.html)

Tones

Returning multiple values from a list
 
I am trying to get multiple return answers from a table. I am using the INDEX
combined with the SMALL formula but it doesn't work. Anyone knows of anything
that can?

Peo Sjoblom

Returning multiple values from a list
 
If you are using it as a lookup to extract multiple values where there are
multiple lookup values you can see an example here

http://nwexcelsolutions.com/advanced_function_page.htm


it's number 6


you can download a sample as well


http://nwexcelsolutions.com/Download/

--
Regards,

Peo Sjoblom



"Tones" wrote in message
...
I am trying to get multiple return answers from a table. I am using the
INDEX
combined with the SMALL formula but it doesn't work. Anyone knows of
anything
that can?




Toppers

Returning multiple values from a list
 
Perhaps a little more detail of what you are doing would help.

"Tones" wrote:

I am trying to get multiple return answers from a table. I am using the INDEX
combined with the SMALL formula but it doesn't work. Anyone knows of anything
that can?



All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com