How to look up a value in a list and return multiple corresponding

I followed the instructions on the excel help page of how look up a value in
a list and return multiple corresponding values but somethings not right. I
have tried this numerous times in my excel spreadsheet and it does not return
any values let alone numerous values. No values will appear unless I go into
the insert menu and click function, but then here it will only give me the
smallest value, even when there is more than one. Please help asap! Thank
you.

How about giving us some details?

--
Biff
Microsoft Excel MVP


"123456789" wrote in message
...
I followed the instructions on the excel help page of how look up a value
in
a list and return multiple corresponding values but somethings not right.
I
have tried this numerous times in my excel spreadsheet and it does not
return
any values let alone numerous values. No values will appear unless I go
into
the insert menu and click function, but then here it will only give me the
smallest value, even when there is more than one. Please help asap! Thank
you.