Wednesday, June 2, 2010

INDEX and MATCH in EXCEL

image

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