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
- Are the income criteria and turnover criteria of 4
- Codonation of delay for filing for 10 BB
- Gst on hired vehicle repair maintenance
- Return defective due to turnover mismatched with I
- Ineligible ITC availed and later reversed under wr
- Temples GST HSN
- Tax filing for the belated payment credit
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
