extracting data from a table

[duneman]

Hi, I am hoping to create a list using the data from a table.

A drop-down date chooses the column is taken from and the numbers in the column indicate the items that I want in the list.

I can use formulae but I'm challenged by getting a whole set of data from one table into another.


Thank you in advance for your help.

Regards
Geoff

 

[bosco_yip]

Try…...................

1] In J6, copied down :

=IFERROR(INDEX(B$4:B$30,AGGREGATE(15,6,ROW(B$4:B$30)-ROW(B$3)/(INDEX(C$4:E$30,0,MATCH(J$3,C$3:E$3,0))>0),ROWS($1:1))),"")

2] In K6, copied down :

=IF(J6="","",INDEX(C$4:E$30,MATCH(J6,B$4:B$30,0),MATCH(J$3,C$3:E$3,0)))

3] Select the other date in J3 dropdown list for testing purpose.

Regards
Bosco

 

[duneman]

Wow, Bosco, that is fantastic.
A wish come true and a couple more formulae to study and learn from!
Many Thanks
Geoff