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 your class is being broadcast to an off-campus location where you are located and the instructor is physically located at the main campus, this class would be an example of a(n) ________
A) distance education course B) external social network C) instant messaging service D) social network
What is wrong with this code?
```class Square { private: int side = 4; public: Square() {side = 4;} void SetSide(int s) {side = s;} };``` A. Nothing is wrong with the code. B. side can’t be initialized in the set. C. side can’t be initialized in the private section. D. no need to initialize in the constructor because it is initialized in the private section.