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.

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.