| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
