HOW TO DO A VLOOKUP


Excel in Excel

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

lookup_value    Cell that contains the value you are looking up (name of employee here)

table_array     Where is your information located, including identifier (name of employee here) and desired information (hours worked)

col_index_num   What column number is your desired data (hours here) found in, column #1 is your first column in the table_array 

range_lookup    Do you want to find an exact match ("FALSE") or an approximate match ("TRUE").

View original post