question archive In cell B19, use the VLOOKUP, RAND, and INDIRECT functions to randomize the retrieval of the demand column from either the Low, Standard, or High named ranges based on the risk retrieved in cell B18
In cell B19, use the VLOOKUP, RAND, and INDIRECT functions to randomize the retrieval of the demand column from either the Low, Standard, or High named ranges based on the risk retrieved in cell B18
Subject:Computer SciencePrice: Bought3
In cell B19, use the VLOOKUP, RAND, and INDIRECT functions to randomize the retrieval of the demand column from either the Low, Standard, or High named ranges based on the risk retrieved in cell B18. The RAND function will serve as the lookup value and the INDIRECT function will serve as the table array. Use range names for all cells in your functions.
