MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto fill / lookup

Posted by Colin on January 10, 2002 3:53 PM

A simple one I'm sure, I have a form type sheet and would like to enter say an Account number in a cell, then from a data sheet in the same workbook the rest of the form is filled in, Address post code area etc, all off the relevant data is on the data sheet in rows and colums. I have used combo boxes for some of the form contact details etc, but unable to get these to work for addresses etc,
Clear as mud?
anyone help please? save me a load of copy and pasting

Posted by Qroozn on January 10, 2002 6:10 PM

why don't you use a vlookup. this wil look up the account number on the accounts sheet and return the relative cells to that account. eg. column3=-address, column4 = post code

Posted by Colin Bell on January 11, 2002 4:53 AM

Will do, when I figure out how they work, will find an erxample use it then maybe understand it?
thanks for the reply Qroozn
As you may gather I am still thick in the ways of excel!