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.)

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.)