Worried Guy
New Member
- Joined
- May 11, 2002
- Messages
- 6
This is a follow on to my earlier mistaken conditional formatting query.
Is it possible, using only Excel functions, for one cell to absolutely reference a second cell value in another worksheet based on the value of a third cell?
I cannot use a nested 'IF' statement as there are 12 different conditions. Can a lookup function fit the bill here to first check the value of the third cell and then fetch the value of specific cell in another 'hidden' sheet.?
Furthermore, if the data is then changed by the user in the first cell, those changes are updated in the second cell.
I have uploaded the source file here.
http://us.f1.yahoofs.com/users/df94e31c/bc/My+Documents/AnnTgtsnotes.xls?bc3J_38AIdk0yVti
Is it possible, using only Excel functions, for one cell to absolutely reference a second cell value in another worksheet based on the value of a third cell?
I cannot use a nested 'IF' statement as there are 12 different conditions. Can a lookup function fit the bill here to first check the value of the third cell and then fetch the value of specific cell in another 'hidden' sheet.?
Furthermore, if the data is then changed by the user in the first cell, those changes are updated in the second cell.
I have uploaded the source file here.
http://us.f1.yahoofs.com/users/df94e31c/bc/My+Documents/AnnTgtsnotes.xls?bc3J_38AIdk0yVti