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...

Formulas cannot include more than two functions.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A contiguous segment of an array is specified using two subscripts, lower and upper. Which expression gives the position of the element in the middle of the array segment?

A) lower + upper / 2 B) lower /2 + upper C) (upper - lower)/2 D) lower + (upper - lower) / 2

Computer Science & Information Technology

A ____ defines the size of the page and its elements as a percentage of the screen width, meaning that a Web page and its elements are wider on a wider screen.

A. fixed layout B. standard layout C. fluid layout D. water layout

Computer Science & Information Technology

Which of the following reduces the deployment cost of a wireless LAN?

A. WPA B. 802.1x C. MIMO D. PoE

Computer Science & Information Technology