Hi Every one
Attaching a Excel document containing a detailed working of Vlookup Function.
Regards
Rangarajan.K
9 Replies
pramodjalandra
(Account Administrator)
(142 Points)
Replied 10 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 Age =VLOOKUP(E14,A2:D7,3)
in the cell where type is Phone =VLOOKUP(E14,A2:D7,4)
pramodjalandra
(Account Administrator)
(142 Points)
Replied 10 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 Age =VLOOKUP(E14,A2:D7,3)
in the cell where type is Phone =VLOOKUP(E14,A2:D7,4)
shailesh agarwal
(professional accountant)
(7642 Points)
Replied 17 January 2009
Thanks , very useful
Kamaraj Mani. N
(Chartered Accountant - Product Manager)
(553 Points)
Replied 16 February 2009
Please read this page also
/forum/messages/2007/12/4801_excel_advanced_filter.asp
Rahul
(Entrepreneur)
(32 Points)
Replied 30 December 2010
The file explains it all!
https://www.finaticsonline.com/Freebies/Vlookup_&_Hlookup_Explained_[Finatics].xlsx
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
