Hello,
I'm trying to essentially do something similar to a vlookup, but instead of it just returning a single result, I want to see all results. I would like to have each result show in a different column.
Here's what I have in mind:
Basic Data Set
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like it to display the values in this format:
<colgroup><col span="3"><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I have found a variety of solutions online incorporating everything from array formulas using Index and Small functions and a non array formula using Index and Aggregate. I CANNOT get any of these solutions to work for me. I have been at this for HOURS and am super frustrated.
If anyone has a solution it would REALLY help me out a ton.
Thanks,
Kristie
I'm trying to essentially do something similar to a vlookup, but instead of it just returning a single result, I want to see all results. I would like to have each result show in a different column.
Here's what I have in mind:
Basic Data Set
Category | Item |
Fruit | Banana |
Fruit | Apple |
Fruit | Peach |
Fruit | Raspberry |
Fruit | Grape |
Fruit | Orange |
Fruit | Grapefruit |
Veggie | Celery |
Veggie | Tomato |
Veggie | Cauliflower |
Veggie | Potato |
Veggie | Brussel Sprouts |
Veggie | Brocoli |
Drink | Soda |
Drink | Water |
Drink | OJ |
Drink | Milk |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like it to display the values in this format:
Value 1 | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | |
Fruit | Banana | Apple | Peach | Raspberry | Grape | Orange | Grapefruit |
Veggie | Celery | Tomato | Cauliflower | Potato | Brussel Sprouts | Brocoli | |
Drink | Soda | Water | OJ | Milk |
<colgroup><col span="3"><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I have found a variety of solutions online incorporating everything from array formulas using Index and Small functions and a non array formula using Index and Aggregate. I CANNOT get any of these solutions to work for me. I have been at this for HOURS and am super frustrated.
If anyone has a solution it would REALLY help me out a ton.
Thanks,
Kristie