Formulas (office 2003,07,10,13,16 Same)

1. Create table:  Insert Tab >>>  Table
2. Dynamic Dropdown List : =INDIRECT("TABLE1")
3. Auto price list : =IFERROR(VLOOKUP(D4,'PRODUCT LIST_Tab_Name_'!A:B,2,FALSE)," ")

Table Name:

Image Added

Dynamic Dropdown List:

Data Menu >>> Data validation sub-menu

Image Added