Excel 2007 : How to insert text in particular cells on single click in excel

Lets suppose I make 3 columns.One for name ,second for age and third for address.Now I want to enter my name i.e.Ankit many times in many rows along with age and address.So is there any way so that when I enter my name, my age and address automatically get inserted in specified columns?

Hello,

yes, you can do that, but Excel has to know your age and address to insert it automatically.

You will need to store that information somewhere in the Excel sheet, then you can use a formula to insert it in your table.

What is the purpose of entering one name several times and showing age and address for that name? Or do you want to enter DIFFERENT names and look up the ages and addresses of DIFFERENT people? That could be achieved with a Vlookup formula.

Provide a bit more info, then it will be possible to give more detailed advice.

cheers,

Thank you very much for the help.It was same that I was looking for.I have understood vlook up from a tutorial and all credit goes to you.Thanks a ton.
But there comes a problem when I use that formula for the whole column.When I copy that formula down the column using drag then it increment the row number(lookup_value) but also increment the lookup table array values(table_array) which is stationary(i.e. same source location).And as a result it gives N/A in each cell.So I want a method by which when dragging only row number(lookup_value) should increment but not table_array.

Hello,

you need to use absolute references for the table array.

=Vlookup(A1,$C$1:$B$100,2,false)

when this formula is copied down, the A1 will change to A2, A3, A4, etc. but the $C$1:$B$100 will stay as $C$1:$B$100

cheers, teylyn

okayyy.....thanks a lot!!
i have come to this site first time and its very supportive.
nice work..

Glad to be of help. Now please remember to mark the thread solved and please do not quote whole posts when responding. It just creates clutter and work for the moderators.

thanks,