PDA

View Full Version : Solved: Using String in a cell as reference for a cell



mark.miller9
05-27-2008, 09:10 AM
I have a lookup function that finds the row of a number that is closest to another dynamic number taken from an RTD and so can create a cell that has say "A5", but as the comparison for the lookup is changing, the row will also change. I wanted to find out if it was possible to use the "A5" in the cell, say "E6", in a further function. E.g. if(A5<10, ...). Can easily do this within a macro, but since the original comparison will be dynamic I dont want to have a macro running constantly in the background stopping any further use of excel.

Many thanks
Mark

Bob Phillips
05-27-2008, 09:58 AM
=INDIRECT(E6)

mark.miller9
05-28-2008, 04:53 AM
That is perfect, thanks very much