View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cinco Cinco is offline
external usenet poster
 
Posts: 29
Default Need cell value not cell pointer returned from formula

In the following formula, I want the cell value for the expression "H" &F5+1
not the cell pointer returned when G3-H3 is 0"

If((G3-H3)=0,"H" &F5+1,(G3-H3)

My formula specification when (G3-H3) = 0 returns H356. What I want is the
value in H356 (column H, row 356) F5 contains the relative row number in an
array.
Is there some way to specify this so that I get the contents of the cell
rather than a pointer to the cell? Thanks for your help on this.