HOW V LOOK COMMAND OPERATE IN EXCEL???????????????/
MANI SOLANKI
CA jayalakshmi
(Associate consultant)
(235 Points)
Replied 04 December 2008
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))
Rajdeep Pawar
(Service)
(329 Points)
Replied 04 December 2008
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.
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
