You can do it using =INDEX($B$2:$B$25,MATCH(B28,$A$2:$A$25,1))