VLOOKUP foumula, as the formula name show its use. This formula is use when we have data in bulk and we have to find one person detail.
SYNTEX: =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Lookup_value = Select the cell which you find
Table_array = Select the whole table
Col_index_num = Column number is the table have the numer of column
range_lookup = 0 (zero is true value)
Here is an Example of vloolup
Here is the link
https://docs.google.com/spreadsheets/d/1GmZYiQ6-J_qKjteDQIJcaNu_vLOK4b23nWt_zitpc5w/edit#gid=0`
SYNTEX: =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Lookup_value = Select the cell which you find
Table_array = Select the whole table
Col_index_num = Column number is the table have the numer of column
range_lookup = 0 (zero is true value)
Here is an Example of vloolup
Here is the link
https://docs.google.com/spreadsheets/d/1GmZYiQ6-J_qKjteDQIJcaNu_vLOK4b23nWt_zitpc5w/edit#gid=0`
No comments:
Post a Comment
Thank you for comment.