Returning multiple values from a list

[Guest]

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]

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/

 

[Guest]

Perhaps a little more detail of what you are doing would help.