Vlookup Function Explained

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: 578 times
Replies (9)

Thanks , very useful

thnx for the useful file.

Fine very necessary.

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)

 

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)

Originally posted by :CA Rajesh S
" Thanks , very useful "


 

Thanks , very useful

Please read this page also

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

The file explains it all!

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details