| Widget Connector | ||
|---|---|---|
|
Formulas (office 2003,07,10,13,16 Same)
- Create table: Insert Tab >>> Table
- Dynamic Dropdown List : =INDIRECT("TABLE1")
- Auto price list : =IFERROR(VLOOKUP(D4,'PRODUCT LIST_Tab_Name_'!A:B,2,FALSE)," ")
Table Name:
Dynamic Dropdown List:
Data Menu >>> Data validation sub-menu
