Executive Human Resource Manager Interview Questions and Answers

V-look up is a function in Excel used to search for a specific value in a table and return a corresponding value.

• Select the cell where you want the result to appear

• Go to the 'Formulas' tab and click on 'Lookup & Reference'

• Select 'VLOOKUP' from the dropdown menu

• Enter the value you want to search for in the 'Lookup_value' field

• Select the table range in the 'Table_array' field

• Enter the column number of the value you want to return in the 'Col_index_num' field

• Choose whether you w...read more