Excel VLOOKUP Function Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Scenario: You want to check if a certain word exists from the list and get the corresponding row value. Procedure: Select the array of data.In below image I selected A1 to C4 . So, if you want to get the address of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,2,FALSE) Note: lookup_value is not case sensitive. if you want to get the price of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,3,FALSE) We only change the col_index_num into 3.