Question

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 1

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.

Step-by-step 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.