K Kenshin Member Sep 20, 2016 #1 Hello excel expert please kindly find my file attach that I have questions describe on the file, my thanks for everyone look for this, thank you all. Attachments Questions.xlsx Questions.xlsx 8.3 KB · Views: 11
Hello excel expert please kindly find my file attach that I have questions describe on the file, my thanks for everyone look for this, thank you all.
N NARAYANK991 Excel Ninja Sep 20, 2016 #2 Hi , How do we know that there is no more data for Andi , after we have displayed the three items shoe , soap and shampoo ? Upload your actual working file instead of a file with this kind of data. Narayan
Hi , How do we know that there is no more data for Andi , after we have displayed the three items shoe , soap and shampoo ? Upload your actual working file instead of a file with this kind of data. Narayan
Marc L Excel Ninja Sep 20, 2016 #3 Hi ! What a bad data design ! Would be easier with data in rows …
B bosco_yip Excel Ninja Sep 20, 2016 #4 Try…… 1] Select dropdown list in C5 2] D5 formula copy down : =IF(ROWS($1:1)<=($C$5<>"Irna")+2,INDEX(A$2:A$12,MATCH($C$5,$A$2:$A$12,0)+ROWS($1:1)),"") Regards Bosco Attachments TableLookup1.xlsx TableLookup1.xlsx 8.8 KB · Views: 8 Last edited: Sep 20, 2016
Try…… 1] Select dropdown list in C5 2] D5 formula copy down : =IF(ROWS($1:1)<=($C$5<>"Irna")+2,INDEX(A$2:A$12,MATCH($C$5,$A$2:$A$12,0)+ROWS($1:1)),"") Regards Bosco
K Kenshin Member Sep 20, 2016 #5 @bosco_yip waaaaa amazing, thanks sir for your effort and excellent formula, appreciated