hi community

when an example i want to create a list and uses a lookup function to
extract the info reference by the custom list.
now...
if my reference info consist of multiple data, example

A B C
1 1 Apple
2 1 Orange
3 2 Melon
4 3 Strawberry
5 3 Jack Fruits
6 3 Honey Dew

base on the above range data, I wanted to create a custom list (that gives
me a drop down button), and when I select, example, (1), the cell that uses
the lookup funtion will display for me in this manner,

Col Col
Row 1 Apple
Orange

I can use it for a single reference data and lookup for single value, is it
possible for me to design such like the display in the immediate above and
if do, can assist on how to ?


thanks community :)



--
oldLearner57