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 :
- Tax Benefit on Second Property
- IPO application checklist: 18 rules that decide wh
- NSE IPO Price, GMP, Allotment Date and Listing
- Gst tax rate
- Cash deposited by customer
- CAPITAL GAIN REG
- Built a simple tool to automate client document fo
- Capital Gain on Sale of SRA Allotted Flat Received
- Discrepancy in Auto populated figures in GSTR1 of
- What should I do after receiving a GST Show Cause
Related Topics :
CAclubindia
