VLOOKUP - this looks for a value in the leftmost column of a table, and then returns a value in the same row froma column you specify. By default, the table must be sorted in an ascending order.
VLOOKUP(lookup_value,table_array,col_index_num,...)
EXAMPLE: If I want to find the grade of "A" in Subject 1 and have the result returned in cell G2, then the formula should be written as shown below:
HLOOKUP - this looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify.HLOOKUP (lookup_value,table_array,row_index_num,...)
EXAMPLE: Now, using the same example above, let's try to find the grade of "A" in Subject 1 using HLOOKUP.
