HOW V LOOK COMMAND OPERATE IN EXCEL???????????????/
MANI SOLANKI
2 Replies
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.
Recent Topics
- Applicability of 44AD needs clarification
- ITC reversal in GST 3B
- Claim if ITC on stocks 19-2020 conversion from com
- Urgent doubt on GST
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
Related Threads
CAclubindia
