Hi
IF(INDIRECT(AW10)=W),1,2.....

--
Regards
Frank Kabel
Frankfurt, Germany

ParTeeGolfer wrote:
I am Tring to figure out how to use a referance from a cell and use
that address in a formula not the value

EXAMPLE: AW10=AD13 AD13=W

IF(AW10=W),1,2........Where AW10 in the formula I really need to
referance the cell AD13 in the If statement. The Value AD13 can
change from ad13 to AD45

can anyone help!