Forum Discussion
gab2020
Jul 14, 2020Copper Contributor
Match multiple criteria from Different Worksheets and return a Value
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 ...
- Jul 14, 2020
Here
it could be
=IF(ISNA(MATCH(C2,INDEX(Sheet1!D:I,MATCH(B2,Sheet1!C:C,0),0),0)),"Unavailable",C2)
gab2020
Jul 16, 2020Copper Contributor
Thanks SergeiBaklan. It's working good. 🙂
SergeiBaklan
Jul 17, 2020Diamond Contributor
gab2020 , you are welcome