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

by 


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

1

solved How to do multiple lookup and results in Excel?