ExcelBanter - Cell referance for formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell referance for formula (https://www.excelbanter.com/excel-worksheet-functions/8514-cell-referance-formula.html)

ParTeeGolfer

Cell referance for formula

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!

Frank Kabel

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!

ParTeeGolfer

"Frank Kabel" wrote:

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!

Thanks Frank, This solved my problem

All times are GMT +1. The time now is 04:44 AM.