thanx
Understand VLOOKUP Formula
Page no : 2
NISHIT A. DOSHI
(ARTICLE ASSISTANT)
(224 Points)
Replied 24 November 2009
absolutely very nice one.
thanks.
with regards,
c.a.nish*t doshi
CA. Dashrath Maheshwari
(TaXpert)
(15103 Points)
Replied 24 November 2009
| Originally posted by :Mayank Ahuja | ||
| " | nice presentation.......... Thanks But there is my 1 query: When we put vlookup in one cell "W" in your example.. Do we have 2 set formula of vlookup in each cell separately (in s, gaurav, t, h, as so on)......OR we can drag the cell 2 copy the remaining cell.. Is there any shortcut for the same? I hope u understand my query...... pls reply |
" |
you can drag the formula but you have to make few corrections like column no. given after series address has to be changed.
CA Urvi
(executive)
(36 Points)
Replied 25 November 2009
good one Prakash, pl provide easy way to understand HLOOKUP. Thanks.
CA Ayush Agarwal
(Kolkata-Pune-Mumbai)
(27186 Points)
Replied 02 December 2009
thanks, any one have a file to understand table & index in ms word. in insert menu.
Rahul Bansal
(Finalist)
(35929 Points)
Replied 08 December 2009
thanks.............keep it up prakash
Kamaraj Mani. N
(Chartered Accountant - Product Manager)
(553 Points)
Replied 23 June 2010
See this file.. You will new ideas to use Vlookup Function.
/share_files/vlookup-new-usage-3240.asp
Srikanth Telanakula
(Employment)
(22 Points)
Replied 30 June 2010
ok i understood VLOOKUP formula
whats about HLOOKUP i met problem with this while working
can you assist me on this
sri..
Attached File : 28 46 understand vlookup formula.xls downloaded: 168 times
Ram Avtar Singh
(Nagari Sultanpur U.P.Delhi)
(14487 Points)
Replied 12 November 2010
Srinath ji Hlookup formula for you
Attached File : 23 copy of 28 46 understand vlookup formula.xls downloaded: 142 times
Recent Topics
- How can I check the platform number for my train?
- Gratuity under CTC
- GST refund paid as estimated tax liability
- Salary Income and Professional services income
- Sec 54 and TDS on sale of property
- Airbnb Manager - I manage properties for owners
- Wrong head ed for late fee
- Inter Company trnafer
- Job work-Reg
- Who is liable to pay GST if bank charges excl GST
Related Threads
Trending Online Classes
-
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
Mr.Balamurugan Ranganathan15 November 2024
CAclubindia
