HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. The format of the VLOOKUP function is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup). The lookup_value is the user input. This is the value that the function uses to search on.