As Rick pointed out, you probably have simplifies you needs.

Maybe more numbers needed?

=LOOKUP(O85,{1,2,3,4,5,6,7},{2,4,6,8,10,12,14}) entered in I32


Gord Dibben MS Excel MVP


On Mon, 14 Jul 2008 14:49:01 -0700, Rob wrote:

Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted in
I32.