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 Topic
- Happy CA Day!!
- Share your proudest CA moment 🏆
- Gift recd from brother
- How to show Loan write off in DPT 3?
- Form 10E and Salary arrear
- LTCG U/S 54F. Sale of property plus sale of share
- Issue with ITR2 online utility for HUF
- TDS deducted by EPFO under wrong section
- Schedule SI in ITR-2
- What is the easy way to do CA- through foundation
Related Topics
CAclubindia
