Hey say for example I had already entered about 25 names in an excel sheet along with corresponding PAN in parallel cells. Now when I need to enter a persons name again, on typing starting alphabets of a persons name it autofills for me based on previous data. Any way by which I can get the corresponding PAN also auto filled along with the name when I just type the starting alphabets of the name?
Menu
Excel help.
Replies (5)
Have you tried Vlookup?
Vlookup will help you in this scenario. As and when you will press Enter after getting the name in desired cell your PAN number will automatically come but only thing is you must have used Vlookup formula in the desired cell.
If you have any problem , do send me your file on
shah.varsh*t @ icai.org
regards
Varsh*t
Not wrt any file, it was just to gain some knowledge as I don't know much about excel:)
Dear Kartikeyan ,
Pls find attached copy for your reference. I hope this will help you in understanding in framing of formula.
Varsh*t
. I hope this karthikeyan
Read more at: /forum/details.asp?mod_id=223358&offset=0#.UHOi8VHy2So
Read more at: /forum/details.asp?mod_id=223358&offset=0#.UHOi8VHy2So
Thank you soo much:) sure was helpful.
Recent Topics :
- 12A registration expired in FY 22-23 and is not re
- Seeking Clarification on Business Code Selection a
- CG on property sold after construction of a house
- Nursing Home Taxability
- CA opted for Form 10IEA mistakenly - Demand raised
- Query on scenario related to FAST DS 2026
- Audit Executive (Remote, India) - Ace Auditing Off
- GST Transaction On Used Clothing
- ITC availed on 5%-rate passenger transport (AC bus
- Extension of Due Date of AY 2026-27
Related Topics :
ARTICLESHIP
07 September 2026
Article/ Paid Assistant
Murali and Sumeet Chartered Accountant
Bengaluru
CA Foundation
View Details
Featured
11 September 2026
Audit Executive
RBSM Corporate Advisors Private Limited
Pune
CA
View Details
ARTICLESHIP
21 September 2026
CA Article Assistant
KK & Company Chartered Accountant
Pune
CA Inter
View Details
ARTICLESHIP
01 September 2026
Articles
Saini Pati Shah & Co LLP, Chartered Accountants
Mumbai
CA Foundation
View Details
CCI
Pro
CAclubindia
