IB Group MIS Executive Interview Questions, Process, and Tips for Experienced

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) - searc...read more

HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.

• HLOOKUP stands for Horizontal Lookup.

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

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Example: =HLOOKUP(100, A1:D4, 3, FALSE) - searches...read more

To use all formulas in Excel, enter the formula in a cell, use appropriate syntax, and reference cells correctly.

• Enter the formula in a cell by starting with an equal sign (=)

• Use appropriate syntax for the formula (e.g. SUM(A1:A10) for summing a range of cells)

• Reference cells correctly by selecting them or typing their cell references (e.g. A1)

• Use functions like SUM, AVERAGE, IF, VLOOKUP, etc. to perform calculations o...read more

SAP Movement type is a three-digit key that specifies the type of goods movement in SAP system.

• Used to differentiate between various goods movements in SAP

• Helps in determining the type of transaction being performed

• Examples: 101 for goods receipt, 261 for goods issue, etc.