Match multiple criteria from Different Worksheets and return a Value

[gab2020]

Hi, like to seek expertise on excel formulas.

Looking to match multiple criteria from 2 worksheets and return a value.

1st picture below is from 1st worksheet (Sheet 1).

2nd picture below is from 2nd worksheet (Sheet 2).

Condition: e.g. If B2 matches value in Column C of Sheet 1 and C2 matches any value from Column D to Column I of Sheet 1, then return C2. Else return Unavailable.

Looking for the right formula to match the above condition and return the expected result as indicated in yellow cell below.

Included the excel file for reference. Thank you.

[#2 · Accepted solution]

@gab2020 

Here

it could be

=IF(ISNA(MATCH(C2,INDEX(Sheet1!D:I,MATCH(B2,Sheet1!C:C,0),0),0)),"Unavailable",C2)

[#3]

Thanks @Sergei Baklan. It's working good. :)

[#4]

@gab2020 , you are welcome