View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How to look up a value in a list and return multiple corresponding

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.