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 am having lookup problems, please help

How many times can 1 appear?

--
Biff
Microsoft Excel MVP


"drwainscott" wrote in message
...
I am trying to use the lookup function to find a value from another sheet.
The first one works but if there are muliple values that match then I
cannot
get each one.
EX:
A B
1 dog
2 cat
1 mouse

I would like to run a lookup on column A for the number 1 and retrieve dog
(when context unknown.) Then run another search for the number 1 to
retrieve
mouse (when context unknown.)