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