show information with link
Sample 1,Select the row want to be validaion.(Name is CourseColumn)
Data -> Validity -> Cell Range
key in =CourseColumn(the whole row A name)
then done ald.
Sample 2, Select the first 1 row let said is G2(Name is CodeColumn)
key in =OFFSET(DescriptionStart;MATCH(F2;CourseColumn;0)-1;1;COUNTIF(CourseColumn;F2);1)
and then copy it.
done agn.tht 1 is product code.
Sample 3,same with sample 2.this is PriceColumn(name)
key in =IF(G2="";CourseColumn;INDEX(PriceColumn;MATCH(G2;CodeColumn;0)))
ok ang.
when you choose the course name,the coursecode and te price will show it automatically.
Today's Visitors: 0 Total Visitors: 0
