plzzz REPLyyyyyyyyyyy

Hi Manisha, for vllokup in excel type=vlookup(select the column for which u r creating vlookup,select the column in excel in which u want to select,count the column number in which value u r selectingi.e.A column as 1&B column as 2,(True))

Vlookup stands for vertical lookup & used to lookup a value from a tabular range. the syntax of Vlook up is :

=Vlookup(lookup_value, table_array, col_index_num,[Range_Lookup])

Lookup_Value : is the value which you want to look for.

Table_array : is the tabular area from which you want to lookup the value,

Col_index_num is the number of column (in which you want to lookup the value ) counting from the first column of table array.

Range lookup : here you should enter true when data is alphabetically arranged or false when data is not arranged.