There's no problem with filling a small number of cells with the equation ... try to recreate the lookup ttable so it's only 2 columns wide (=vlookup(A1,B:C,2,FALSE) so the extra columns don ...