Insert a function in the cell H11 that looks up the sales re

Insert a function in the cell H11 that looks up the sales rep region based on the table in cells E3:F6.

Actually, the VLOOKUP funtion can be using for retrieving the data from certain level of cells in excel.

Here the Syntax for VLOOKUP:

VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

this syntax can be easily viewed in excel that is by typing vlookup and holding the cursor then will see the syntax in excel.

for example,

create a database in excel, and then enter formula = VLOOKUP(B11,A1:G3,7,False)