FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -=INDEX() returns the value of a cell in a table based on the column and row number. =MATCH() returns the position of a cell in a row or column. Combined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria.

Detailed explanation-2: -Vlookup is a function which can be used to reference columns from the same sheet or we can use it to refer it from another worksheet or from another workbook, the reference sheet is same as the reference cell but the table array and index number are chosen from a different workbook or different worksheet.

Detailed explanation-3: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column.

Detailed explanation-4: -What Is a LOOKUP Function? Lookup functions in Excel mean referencing a cell to match values in another row or column against the cell and thereby retrieving the corresponding results from the respective rows and columns.