karthikeyan (Chartered Accountant) (522 Points)
08 October 2012Hey 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?
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
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
karthikeyan
(Chartered Accountant)
(522 Points)
Replied 10 October 2012
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
