Answered

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.

Answer :

Answer:

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook is by using lookup functions.

Explanation:

  • Lookup function is the built in function of excel that helps in returning the certain value form specific row or column.
  • When the value is stored in the worksheet we can easily insert that desired value in the cell by the use of lookup functions.
  • VLOOKUP  and HLOOKUP are the lookup unctions that searches the value in column and row respectively.

Other Questions