Hi murphy,

I've never seen VLOOKUPs used like this...

Just simplify your formula to =VLOOKUP($A3,$B$3:$AJ$19,2,FALSE) then copy this to the other columns, but you have to change 2 to 3, and 4 and 5 separately... and you don't have to array enter...

Hopet this helps...