What is the benefit of using MATCH nested with INDEX over lookup functions such as VLOOKUP?
What will be an ideal response?
The MATCH and INDEX function can perform the function of VLOOKUP and HLOOKUP simultaneously when nested together, while also eliminating the need for look up tables. When using both INDEX and MATCH the user will gain the ability to provide two input variables for a vertical and horizontal axis that will then return a value.
You might also like to view...
If you purchase software in a box, it is likely distributed on which type of storage media?
A) DVD B) CD-ROM C) Blu-ray D) Floppy disk
Write the pseudocode for a class named Product that holds a product name. Include methods to get and set the value for each data field.
What will be an ideal response?
How do you toggle on and off which layers are active and visible?
What will be an ideal response?
Which assets must be considered when using asset-based risk assessment?
A) All assets B) Those assets valued at more than a determined threshold C) All intangible assets D) All tangible assets