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
Many thanks
Mark