So, I needed to replace a number and its related value. So easy, the formula is
=INDEX($I$2:$I$7,MATCH(B2,$H$2:$H$7,0))
No comments:
Post a Comment