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

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

tikchye_oldLearner57 wrote:

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

--

Dave Peterson

thanks Dave Peterson for the answered, much appreciated :)

thanks community as well
--
oldLearner57


"Dave Peterson" wrote:

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

tikchye_oldLearner57 wrote:

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

--

Dave Peterson