[Solved] How to do multiple lookup and results in Excel?

=IF(ISERROR(MATCH(A1,SHEET2!A:A,0)),IF(ISERROR(MATCH(A1,SHEET2!B:B,0)),text3,tex2),text1)