Excel tools to demonstrate

Then enter the formula =VLOOKUP(value,lookup table,column #), as described above. Try it! Enter a lookup table in columns E and F, and VLOOKUP functions in column C. Assume there is a quantity discount policy in force: for orders less than 300 units, the unit price is $3; for orders of at least 300 units but less than 400, the unit price is $2 ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.