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.

Attached Files

ProductPrice.xlsx (12.3 KB, 13 views)