Hi all,

I have a working formula which returns a value from column C:C of Sheet2 after searching and matching a value in column A, however I need to add a second match and no matter how the syntax I try it doesn't work.

The working code is below and the second match would be something like (I112=Sheet2!G:G)

=INDEX(Sheet2!C:C,MATCH(FALSE,ISERROR(SEARCH(A11,Sheet2!A:A)),0)+0)
Any help on how I can incorporate it would be appreciated.