In the given spreadsheet, columns A though Esepresent a data table. However, there are missing values in columns $C$ through $E.$ In cell $J1$ there is a lookup table containing columns for Product, Product ID$,$ and Unit Price. Your first task is to fill in the missing values in columns C$,$ D$,$ and E using VLOOKUP and the lookup table. Doing this manually would take a long time and be very tedious. The best way is to use VLOOKUP to fill in the first row of missing data and then drag down to fill the remaining rows.

In cell C$2,$ populate the Product ID of the first item using VLOOKUP. The value you wish to look up in the lookup table is in Column A$,$ cell A$2$ to be exact. The lookup table is cell range $$J$$$1$:$$L$$$6.$ Note that these are absolute cell references since the look up table is in a fixed location. The Product ID is in the second column of the lookup table. And finally set the range$\_$lookup parameter to FALSE.