Forum Discussion
Solved
Lookup / Index / Match formula
Hi, Hope someone here could help me with a formula which I think could be a Index/match/lookup formula. I have static conditions in columns F:H. These are always true together otherwise not...
With some assumptions that could be one of
=IFNA(LOOKUP(2,1/(A2=$F$2:$F$9)/($G$2:$G$9=B2),$H$2:$H$9),"") or =IFNA(INDEX($H$2:$H$9,MATCH(1,INDEX((A2=$F$2:$F$9)*($G$2:$G$9=B2),0),0)),"") or =XLOOKUP(A2&B2,$F$2:$F$9&$G$2:$G$9,$H$2:$H$9,"")or like
With some assumptions that could be one of
=IFNA(LOOKUP(2,1/(A2=$F$2:$F$9)/($G$2:$G$9=B2),$H$2:$H$9),"")
or
=IFNA(INDEX($H$2:$H$9,MATCH(1,INDEX((A2=$F$2:$F$9)*($G$2:$G$9=B2),0),0)),"")
or
=XLOOKUP(A2&B2,$F$2:$F$9&$G$2:$G$9,$H$2:$H$9,"")or like
SergeiBaklan Truly amazing. It worked perfectly! This is so much appreciated. Thanks for making my night! 🙂
viktor2170 , you are welcome
