So, as you can see from the example google sheet below, is there any way to have a formula in which when you try to find the value from both sheets (Example 1, Example 2; if lets say in Example 3, when you try to find the value in Example 1 sheet, it finds nothing and it proceeds to Example 2 sheet to look for the value and if there's any value found, it will return the value to the respective cell)
If =iferror(vlookup(C2,Example1!B:C,2,false)) is empty, try =iferror(vlookup(C3,Example2!B:C,2,false)) to find value in 2 different sheets
FALSEin your example sheet as well. Sorry to repeat myself: could you probably just want to have the two values returned in one formula. Would that be sufficient?