May 02 2022 12:56 PM
I need to autopopulate cells based on a separate list of criteria. I have an excel crosswalk of account codes, where one column has the old code and the other column has a new code. On a separate sheet, I would like to input the old code in one column and have the new code autopopulate in the adjacent column.
May 02 2022 01:08 PM
=IFERROR(INDEX(sheet1!$B$2:$B$23,MATCH(sheet2!A2,sheet1!$A$2:$A$23,0)),"")
Maybe with this formula which is entered in range B2:B25 in sheet2. You can enter an old account number in range A2:A25 in sheet2 to autopopulate the new account number.
May 03 2022 06:34 AM
May 03 2022 10:17 AM
SolutionMay 03 2022 10:17 AM
Solution