Vlookups on several file paths

%3CLINGO-SUB%20id%3D%22lingo-sub-1387727%22%20slang%3D%22en-US%22%3EVlookups%20on%20several%20file%20paths%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387727%22%20slang%3D%22en-US%22%3EDear%20Excel%20community%20and%20users%2C%20is%20there%20a%20way%20of%20using%20a%20vlookup%20over%20several%20filepaths.%20I%E2%80%99ve%20seen%20nested%20%E2%80%9Ciferror%E2%80%9D%20but%20I%E2%80%99m%20not%20sure%20if%20it%20works%20with%20a%20lot%20of%20different%20filepaths.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1387727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388305%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookups%20on%20several%20file%20paths%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388305%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666974%22%20target%3D%22_blank%22%3E%40NewbieTTM%3C%2FA%3E%26nbsp%3BYes%20%3DIFERROR%20works%20for%20me%20perfectly%20fine%20with%20different%20files.%20What%20it%20does%20is%20when%20the%20data%20is%20not%20found%20it%20again%20try%20to%20find%20the%20data%20with%20a%20different%20path%20as%20specified%20and%20the%20process%20continue%20as%20long%20as%20you%20have%20made%20it.%20You%20can%20give%20a%20try%20or%20let%20us%20help%20you%20with%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Dear Excel community and users, is there a way of using a vlookup over several filepaths. I’ve seen nested “iferror” but I’m not sure if it works with a lot of different filepaths.
1 Reply
Highlighted

@NewbieTTM Yes =IFERROR works for me perfectly fine with different files. What it does is when the data is not found it again try to find the data with a different path as specified and the process continue as long as you have made it. You can give a try or let us help you with it.