Excell: table and vlookup

Owned by Jean-luc KRIKER
Last updated: Dec 01, 2019
1 min read




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:


Dynamic Dropdown List:

Data Menu >>> Data validation sub-menu