formula help I think

Copper 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

@clenormand 

See the attached sample workbook.

Thank you, I will try that. @Hans Vogelaar