Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell pointer position | Excel Discussion (Misc queries) | |||
Pointer and Cell | Excel Discussion (Misc queries) | |||
Cell pointer | Excel Discussion (Misc queries) | |||
Find cell which returned maximum value in formula | New Users to Excel | |||
How do i add cell values that are returned via a formula | Excel Discussion (Misc queries) |