Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the main limitation of VLOOKUP compared with INDEX-MATCH?

  1. A VLOOKUP can only search rightwards and uses a hard-coded column index
  2. B VLOOKUP cannot do exact matches
  3. C VLOOKUP only works on numbers
  4. D VLOOKUP is slower on small datasets
Answer

VLOOKUP can only search rightwards and uses a hard-coded column index

Inserting a column silently changes what the column index points at, returning wrong data with no error. INDEX-MATCH is immune to this.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as