What is the primary advantage of using the MATCH and INDEX combination versus a VLOOKUP function?
What will be an ideal response?
The combination of the MATCH and INDEX functions can search any column and return a value from any column without regard to the relative position of the two columns.With the VLOOKUP function, the search column has to be to the left of the result column.
Computer Science & Information Technology
You might also like to view...
Endnotes are found at the ________ of a document
Fill in the blank(s) with correct word
Computer Science & Information Technology
Which tool can be used to manage disks and partitions in Windows 10?
Disk Management Defragment and Optimize Disk Cleanup Task Manager
Computer Science & Information Technology