I am not sure this is the right way to go about it but could you explain what 99^99,--RIGHT does? Your formula works great =LOOKUP(99^99; --100*RIGHT(D30; ROW(1:10))) but I don't understand that part? If you have time Ken g48dd
