Yes, see my reply in the other branch of this thread.

--
Biff
Microsoft Excel MVP


"ORLANDO VAZQUEZ" wrote in message
...
Can this formula be modified so that the results appear in rows rather
than
the one column?
Reason is I want to be able to copy the formula down to each row to apply
to
each row and results sprawling out to right.



"T. Valko" wrote:

Thanks for feeding back!

You don't want to move data to accommodate a formula, you want to be able
to
write the formula to accommodate the data.

That's why it's good idea to tell us where your data *really is located*
and
where you want the results to appear. Very few people do this, though!!!

--
Biff
Microsoft Excel MVP


"ORLANDO VAZQUEZ" wrote in message
...
I moved my data to correspond to the formula and it works great. Thank
you!


"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