問題是這樣的我在 Sheet1 建立清單, 並在 Sheet2 實現主清單內的子清單. 之前有找到INDIRECT(), 但實現不出來. 希望幫忙指教, 謝謝.
例如:
主類別為
MARKET [為主清單命名]
ADVANCED DRIVER ASSISTANCE SYSTEMS (ADAS)
BODY ELECTRONICS & LIGHTING
HYBRID, ELECTRIC & POWER TRAIN SYSTEMS
INFOTAINMENT & CLUSTER
PASSIVE SAFETY
當我選到 ADVANCED DRIVER ASSISTANCE SYSTEMS (ADAS) [為子清單命名], 只顯示下拉子清單的項目
ADVANCED DRIVER ASSISTANCE SYSTEMS (ADAS)
Other Automotive Camera
Rear Camera
Driver Monitoring
Mirror Replacement / CMS
Drive Recorder/ Camera DVR / Black Box
Surround View System ECU
Front Camera
Camera Module without Processing
Night Vision
Scanning LIDAR
ToF (Time of Flight)
