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?
5 Replies
Varshit Shah
(Self Employed)
(676 Points)
Replied 08 October 2012
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
karthikeyan
(Chartered Accountant)
(522 Points)
Replied 09 October 2012
Not wrt any file, it was just to gain some knowledge as I don't know much about excel:)
Varshit Shah
(Self Employed)
(676 Points)
Replied 09 October 2012
Dear Kartikeyan ,
Pls find attached copy for your reference. I hope this will help you in understanding in framing of formula.
Varsh*t
Attached File : 108416 1068124 pan vlookup.xlsx downloaded: 183 times
karthikeyan
(Chartered Accountant)
(522 Points)
Replied 10 October 2012
Thank you soo much:) sure was helpful.
Recent Topics
- Regarding Perquisite Tax on ESOP - Unlisted Compan
- Casual Taxable Person under GST
- Extended Date of GSTR-1 for the month of July 2020
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
- Rectification Applications for Past GST Demands
- GST Invoices Series
- FILING OF ITR AY 20-21
- CLAIMING OF UNCLAIMED RCM
Related Threads
CAclubindia
