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
Thank you soo much:) sure was helpful.
Recent Threads
- F&O losses
- Is form 10 IE needed in this case?
- TDS on purchase of property more than 50 lakhs
- Withdrawal from post NSS
- Section 10(11) or 10(12) of exempted income
- New income tax act
- Duplication of Interest on SCSS deposits in postof
- Declaration of foreign investment
- Parent buying property for major child
- LIC maturity amount filing missed
Related Threads
CAclubindia
