Vlookup Function Explained

Excel 2942 views 9 replies
User Avatar

CA Student
200 Points Joined June 2008

Hi Every one

Attaching a Excel document containing a detailed working of Vlookup Function.

Regards

Rangarajan.K

Attached File : 0 vlookup 06.07.08.xls downloaded: 516 times
Reply Share Follow
On 08 July 2008 at 19:34 Report
Replies (9)
User Avatar

Chartered Accountant
1581 Points Joined July 2007

Thanks , very useful

Reply
On 08 July 2008 at 20:15
User Avatar

CA Practice
1818 Points Joined March 2007

thnx for the useful file.

Reply
On 08 July 2008 at 20:15
User Avatar

Accountant
53 Points Joined June 2008

Fine very necessary.

Reply
On 08 July 2008 at 20:48
User Avatar

Account Administrator
142 Points Joined July 2008

rollno name age phone
1 raja 45 4562
2 sanju 23 4558
3 rajesh 4 5623
4 kailash 5 1224
5 krupesh 12 4251
6 pramod 78 452

Vlook up formula Apply here:-

Above data is first coloumn is rollo no. , second is Student name, third is Age and last is Phone no.

Vlook Up Apply here
   
   
Roll No. 2
Name sanju
Age 23
Phone 4558
in the cell where type is Sanju            =VLOOKUP(E14,A2:D7,2)

in the cell where type is Age                =VLOOKUP(E14,A2:D7,3)

in the cell where type is Phone           =VLOOKUP(E14,A2:D7,4)

 

Reply
On 10 July 2008 at 09:06
User Avatar

Account Administrator
142 Points Joined July 2008

rollno name age phone
1 raja 45 4562
2 sanju 23 4558
3 rajesh 4 5623
4 kailash 5 1224
5 krupesh 12 4251
6 pramod 78 452

Vlook up formula Apply here:-

Above data is first coloumn is rollo no. , second is Student name, third is Age and last is Phone no.

Vlook Up Apply here
   
   
Roll No. 2
Name sanju
Age 23
Phone 4558
in the cell where type is Sanju            =VLOOKUP(E14,A2:D7,2)

in the cell where type is Age                =VLOOKUP(E14,A2:D7,3)

in the cell where type is Phone           =VLOOKUP(E14,A2:D7,4)

Reply
On 10 July 2008 at 09:07
User Avatar

Guest
441030 Points Joined August 2012
Originally posted by :CA Rajesh S
" Thanks , very useful "


 

Reply
On 03 October 2008 at 12:43
User Avatar

professional accountant
7647 Points Joined September 2008
Thanks , very useful
Reply
On 17 January 2009 at 19:27
User Avatar

Chartered Accountant - Product Manager
553 Points Joined September 2007

Please read this page also

/forum/messages/2007/12/4801_excel_advanced_filter.asp

Reply
On 16 February 2009 at 19:25
User Avatar

Entrepreneur
32 Points Joined December 2008

The file explains it all!

https://www.finaticsonline.com/Freebies/Vlookup_&_Hlookup_Explained_[Finatics].xlsx

Reply
On 30 December 2010 at 18:04


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