| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change cell referance based on value
A1 in sheet1 contains a reference to a cell in sheet2:
=sheet2!G4 what I want to include in the above formula is a reference to a cell value in sheet1 B1: =IF(NOT(B1="option1"),=sheet2!G4,(B1="option2"),=s heet2!K7) The above is clearly not correct but is only a way to illustrate what I am trying to explain. If you find it difficult to make sense of it I will try to explain in a better way. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
