# Find value in 2 different sheets

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

Thank you.

• Welcome. Please correct me if I am wrong. From your sheet I understand -rephrasing your question - that you could want to have the two values returned in one formula. Would that be sufficient? Dec 11, 2019 at 22:14
• Hi, i managed to solve it and found the formula: =if(iferror(vlookup(C2,Example1!B:C,2,false))="",vlookup(C3,Example2!B:C,2,false)) To return the value if it is found in either one of the 2 sheets. That was what i was asking. But somehow that code works but, for some values in my other sheet it's returning 'FALSE' but not for some others, why? Dec 11, 2019 at 22:26
• This returns `FALSE` in 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? Dec 11, 2019 at 22:37
• Just 1 value, the formula to find in the first sheet and if it doesn't find anything there, proceed to the second sheet, so in the end we will only have 1 value returned. Dec 11, 2019 at 23:12

A workaround would be to use curly brackets `{}`

For "Bananas" use the following formula

``=QUERY({iferror(vlookup(C2,Example1!B:C,2,false));iferror(vlookup(C2,Example2!B:C,2,false))},"select * where Col1 is not null")``

You could also use a "corrected" form of your mentioned formula

``````=IFS(iferror(vlookup(C2,Example2!B:C,2,false))="",vlookup(C2,Example1!B:C,2,false),iferror(vlookup(C2,Example1!B:C,2,false))="",vlookup(C2,Example2!B:C,2,false))
``````

• "Nono, not using arrays". Why not if it solves your issue? In any case the updated formula does not return any `#REF!` Dec 11, 2019 at 23:55