You only have to enter them once... then you can copy or fill the
rest. Are you typing/using the function wizard to enter the vlookups?

Cliff Edwards