a list

[Guest]

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

 

[Dave Peterson]

If you rearrange your data and give it nice names, you may be able to use
Data|Validation and some dependent lists.

Debra Dalgleish explains it:
http://contextures.com/xlDataVal02.html

 

[Guest]

thanks Dave Peterson for the answered, much appreciated

thanks community as well