Jul 14 2020 12:09 AM
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.
Jul 14 2020 11:36 AM
SolutionHere
it could be
=IF(ISNA(MATCH(C2,INDEX(Sheet1!D:I,MATCH(B2,Sheet1!C:C,0),0),0)),"Unavailable",C2)
Jul 16 2020 11:57 PM
Thanks @Sergei Baklan. It's working good. :)
Jul 17 2020 10:43 AM
@gab2020 , you are welcome
Jul 14 2020 11:36 AM
SolutionHere
it could be
=IF(ISNA(MATCH(C2,INDEX(Sheet1!D:I,MATCH(B2,Sheet1!C:C,0),0),0)),"Unavailable",C2)