I'm creating a simple database and I want to be able to populate cells in a column (let's call it USERS) either via a VLOOKUP formula based on entries in another column (USER NUMBERS), or by typing in data directly into the cell in the USERS column. And I want to retain the formula if users do the second method. Is this possible? I thought maybe I could create a third column (USER'S LOOKUP) and have it link to the USERS column, but that won't work. Or will it?

I would attach the workbook, but it contains personal information. If you need me to create a sample workbook, I can.

Any ideas would be appreciated.

Thanks, Bruce