MIS Specialist Interview Questions and Answers

Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.

• Index function returns the value of a cell in a table based on the row and column number provided

• Match function returns the position of a value in a range

• Index+match is commonly used instead of Vlookup for more flexibility and accuracy

• Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value in the 3rd column of the row where 123 is found in column ...read more

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and retur...read more