I have a spreadsheet that is provided to me each month to post in the general ledger.  Is there a way to insert a column and then have it populate the column with account numbers from another spreadsheet/list?

example

Main spreadsheet would have name & amount and the second spreadsheet would list the names with account numbers.  I am trying to figure out how I can have it auto populate the account numbers into the main sheet with out having to go in and key each account number in.    

Hi automatically inputing identifier in a cell based,

According to your description, I test in my own computer and I suggest you to use VLOOKUP formula to get your result. As shown in the following figure.

If you need further help about VLOOKUP formula, please upload a sample file via OneDrive. I am glad to help and forward to your reply.

Hope its helpful.

Regards,

• Edited by guGuuuMy 17 minutes ago