| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Formula reference to cell Based On third Cell Content
I want to build a formula in one cell that calls a second based on the
numeric value in a third. Specifically, Say the frst cell is F10. I want it to look up the number in F1, and then if F1=1, F10=E9*something if F1=2, F10=D9*something if F1=3, F10=C9* something etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
