Instead of reading accross it seems to be reading down.
The V in VLOOKUP is for "vertical". Have you looked into HLOOKUP? (H
is for "horizontal".) That sounds like a better fit.