Please tell me exactly which cells you are using.

Pete

On Jan 2, 10:17*pm, ORLANDO VAZQUEZ
wrote:
Pete,
Can this be modified so the results appear in row 1 horizontally left to
right rather than in column e vertically ? *And can I then copy that formula
down to apply to next row?



"ORLANDO VAZQUEZ" wrote:

Thank you for your support.

Can someone please help me with the following array? type of question.

What formula can I use to return a list of results when there is more than
one result?
If I use VLOOKup it returns only the first instance of the result.

For example: *Looking up cell a1 value of 22 should result in the following
list:
Dog *
Biscuit *
Steak

A *B * * * C * * * D

22 * * * * 34 * * *Apple
33 * * * * 34 * * *Fish
16 * * * * 22 * * *Dog
91 * * * * 1 * * * Orange
15 * * * * 3 * * * Tangerine
14 * * * * 22 * * *Biscuit
21 * * * * 1 * * * Tea
34 * * * * 5 * * * Salmon
17 * * * * 22 * * *Steak
* * * * * *7 * * * Herring
* * * * * *8 * * * Cod
* * * * * *1 * * * Orange
* * * * * *1 * * * Castle- Hide quoted text -

- Show quoted text -