Understand VLOOKUP Formula

Excel 3014 views 25 replies
User Avatar

CA final student
259 Points Joined June 2008

 thanx

Reply Share Follow
On 23 November 2009 at 23:43 Report
Replies (25)
User Avatar

CA final student
259 Points Joined June 2008

 thanx

Reply
On 23 November 2009 at 23:43
User Avatar

ARTICLE ASSISTANT
224 Points Joined April 2009

absolutely very nice one.

thanks.

 

with regards,

c.a.nish*t doshi

Reply
On 24 November 2009 at 06:00
User Avatar

TaXpert
15121 Points Joined September 2007
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.

Reply
On 24 November 2009 at 10:22
User Avatar

executive
36 Points Joined August 2009

good one Prakash, pl provide easy way to understand HLOOKUP. Thanks.

Reply
On 25 November 2009 at 14:25
User Avatar

Kolkata-Pune-Mumbai
27349 Points Joined October 2007

thanks, any one have a file to understand table & index in ms word. in insert menu.

Reply
On 02 December 2009 at 12:35
User Avatar

Finalist
35929 Points Joined September 2009

thanks.............keep it up prakash

Reply
On 08 December 2009 at 21:50
User Avatar

Govt.Job
4401 Points Joined August 2008

 thanks 

Reply
On 22 December 2009 at 16:25
User Avatar

ACCOUNTS OFFICER
25 Points Joined April 2010

SORRY I AM NOT UNDERSTANDING

Reply
On 12 June 2010 at 21:04
User Avatar

Chartered Accountant - Product Manager
553 Points Joined September 2007

See this file.. You will new ideas to use Vlookup Function.

/share_files/vlookup-new-usage-3240.asp

Reply
On 23 June 2010 at 19:11
User Avatar

Employment
22 Points Joined November 2009

ok i understood  VLOOKUP formula 

whats about HLOOKUP i met problem with this while working 

can you assist me on this 

 

sri..

Reply
On 30 June 2010 at 16:34
User Avatar

Nagari Sultanpur U.P.Delhi
15158 Points Joined March 2007

Srinath ji Hlookup formula for you

Reply
On 12 November 2010 at 16:20


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading