My goal is to use the cell address of the first cell in the same row that the active cell is in, as the cell address for the "logical test" part of an IF formula.
I've tried to make myself clearer, but it justs ends up looking more confusing.
I think it would be something like
=IF("first cell in current row"='new disposal entry'!R40C2,'new disposal entry'!R43C2,"""")
Thanks in advance.
Please do not use code tags with formulas - - they are reserved for use only with VBA code.[/COLOR]