formula help I think

New Contributor

I want to set up a spreadsheet that when I enter a GL Account code the account description populates in the adjacent column, and I am not sure how to accomplish this. I have a table set up with the list of accounts and descriptions already. The same GL account code will be used several times in my spreadsheet so I need to make sure that every time the GL Account code is entered into the spreadsheet it will populate with the correct GL Account description

c@clenormand in excel



2 Replies


See the attached sample workbook.

Thank you, I will try that. @Hans Vogelaar