Question: The table _ array argument should identify a range of cells in the 'Product List' worksheet. You can examine the formulas created in the workshop
The tablearray argument should identify a range of cells in the 'Product List' worksheet.
You can examine the formulas created in the workshoptutorial in cells B and B of the W worksheet as an example.
Consider using $ to establish absolute references for columns andor rows that should not change when you copypaste formulas. Be careful, not all arguments in this VLOOKUP should be absolute references.
If you see #NA values appear as prices, then you need to fix the arguments of VLOOKUP, or fix the items number in column A
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
