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?