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?

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?

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?