Excel VLOOKUP Function
Scenario: You want to check if a certain word exists from the list and get the corresponding row value.
Procedure:
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.
- if you want to get the price of Toshiba. we can do it like this.
=VLOOKUP("Toshiba",A1:C4,2,FALSE)
Note: lookup_value is not case sensitive.
=VLOOKUP("Toshiba",A1:C4,3,FALSE)
We only change the col_index_num into 3.
Comments
Post a Comment