Autopopulating cells based on multiple cells from a separate excel sheet

[rosieelman]

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.

[#2]

@rosieelman 

=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. 

[#3]

Thank you for this! I think you might be on the right track I just haven't quite figured out how to input the formula into my sheets.

[#4 · Accepted solution]

This is what worked in the end =VLOOKUP(M5,sheet2!A4:B133,2,FALSE)