using cell data to specify links to other sheets

Originally Posted by pmetzak

Hi I am trying to write a formula on sheet 3 (Template) that will give me data from sheet 1 (Recall_Task) and sheet 2 (Task_CR). The problem I am having is that I cannot write a formula that allows me to use another cell on sheet 3 to reference to correct row to get the data from on sheet 1. I know this sounds confusing but looking at the formula may help.

=IF(AND(LEFT(Recall_Task!B5,4)="read",MID(Task_CR!D(Template!CC2),15,1)="1"),Recall_Task!E5,"")

The problem is that it will not let me use (Template!CC2) to reference the correct row in column D on sheet Task_CR. I am sure this problem has a simple solution.... sorry, I am an excel novice!


If any clarifications are needed please reply or PM me.

Thanks!

Paul

Hi,

try

=IF(AND(LEFT(Recall_Task!B5,4)="read",MID(INDIRECT("Task_CR!D"&Template!CC2),15,1)="1"),Recall_Task!E5,"")

hth
---