Slightly edited version of workbook from Marcia.
Both tables are defined as Tables (this ensures, you don't have to edit formulas whenever you add new data to either of Tables);
The products list referred in Data validation is read as column of product list Table and is now dynamic;
To get price for data entry table, VLOOKUP is used instead of INDEX;
All formulas are using Table syntax.
|