MrExcel Publishing
Your One Stop for Excel Tips & Solutions

using excel as a database

Posted by Chris on February 06, 2002 12:15 PM

I would like to create and excel sheet with account numbers and the names associated with the numbers to use as a database.

I would then like to create a spreadsheet which would allow me to type in the account number, and the the name associated would automatically show up in the next column.

Any help?

Posted by Aladin Akyurek on February 06, 2002 12:17 PM

Have a look at the VLOOKUP worksheet function under Help. [NT]