Ohm Analytics interview question

When should you use index match function in excel?