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