am having lookup problems, please help

D

drwainscott

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index, Match within a range of values 4
Complex lookup issue 2
Lookup with multiple returns 12
Help needed 0
Pivot Table counting a range 1
divide a string words separated by (number) 2
i need to insert data in a large spreadsheet 1
Count unique with criteria 3

Top