Thanks for feeding back - glad it worked for you.

I could see by examining what you wanted to do that the only variable
was the row number for column P and that this was related to the value
in B2. The INDIRECT function allows you to use a calculated cell
reference, so it was then obvious how to convert your formula. Often,
you would use a lookup table to replace multiple IFs, but that wouldn't
work in this case as it was the cell reference you wanted to change
rather than just a value.

Pete

unouwanme wrote:
Yea, that works great thanks.....how do you know things like that??

"Pete_UK" wrote:

Try this:

=IF(OR(B2<1,B210),"",A2+INDIRECT("$P$"&(B2+1)))

Hope this helps.

Pete

unouwanme wrote:
Thanks for all of your help/comments.

Basically all i am wanting to do is:
If the number in this cell is 1 add this to this, if 2 add this to this etc

=If(B2=1,A2+$P$2,if(b2=2,a2+$P$3,if(b2=3,a2+$P$4,i f(b2=4,a2+$P$5,if(b2=5,a2+$P$6,if(b2=6,a2+$P$7,if( b2=7,a2+$P$8,if(b2=8,a2+$P$9,if(b2=9,a2+$P$10,if(b 2=10,a2+$P$11,""))))))))))

Again thank ou for your replies