Vlookup but with multiple results
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
|