SOLVED

Autopopulating cells based on multiple cells from a separate excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3300785%22%20slang%3D%22en-US%22%3EAutopopulating%20cells%20based%20on%20multiple%20cells%20from%20a%20separate%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300785%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20autopopulate%20cells%20based%20on%20a%20separate%20list%20of%20criteria.%20I%20have%20an%20excel%20crosswalk%20of%20account%20codes%2C%20where%20one%20column%20has%20the%20old%20code%20and%20the%20other%20column%20has%20a%20new%20code.%20On%20a%20separate%20sheet%2C%20I%20would%20like%20to%20input%20the%20old%20code%20in%20one%20column%20and%20have%20the%20new%20code%20autopopulate%20in%20the%20adjacent%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3300785%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301631%22%20slang%3D%22en-US%22%3ERe%3A%20Autopopulating%20cells%20based%20on%20multiple%20cells%20from%20a%20separate%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301631%22%20slang%3D%22en-US%22%3EThis%20is%20what%20worked%20in%20the%20end%20%3DVLOOKUP(M5%2Csheet2!A4%3AB133%2C2%2CFALSE)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301365%22%20slang%3D%22en-US%22%3ERe%3A%20Autopopulating%20cells%20based%20on%20multiple%20cells%20from%20a%20separate%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301365%22%20slang%3D%22en-US%22%3EThank%20you%20for%20this!%20I%20think%20you%20might%20be%20on%20the%20right%20track%20I%20just%20haven't%20quite%20figured%20out%20how%20to%20input%20the%20formula%20into%20my%20sheets.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3300792%22%20slang%3D%22en-US%22%3ERe%3A%20Autopopulating%20cells%20based%20on%20multiple%20cells%20from%20a%20separate%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1379121%22%20target%3D%22_blank%22%3E%40rosieelman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFERROR(INDEX(sheet1!%24B%242%3A%24B%2423%2CMATCH(sheet2!A2%2Csheet1!%24A%242%3A%24A%2423%2C0))%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula%20which%20is%20entered%20in%20range%20B2%3AB25%20in%20sheet2.%20You%20can%20enter%20an%20old%20account%20number%20in%20range%20A2%3AA25%20in%20sheet2%20to%20autopopulate%20the%20new%20account%20number.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

3 Replies

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

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.
best response confirmed by rosieelman (New Contributor)
Solution
This is what worked in the end =VLOOKUP(M5,sheet2!A4:B133,2,FALSE)