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: 562 times
Menu
Vlookup Function Explained
Attached File : 0 vlookup 06.07.08.xls downloaded: 562 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 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 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
Recent Topics :
- Utilising Section 54(F) for capital gains reinvest
- GST ewaybill closure and Bill to ship to GST numbe
- TDS ON PARNTER INTEREST
- Share important chapters of ca inter costing
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
Related Topics :
CAclubindia
