Hi guys
I seem to be having a blonde moment. The below formula is returning it's own value and not the value of the cell it's directed at. I've tried several fixes for this now and don't seem to be able to identify what's going wrong!
Could anyone offer a suggestion? I think my brain has failed on this.
="'["&('Data ID List'!A2)&"]"&('Data ID List'!B2)&"'!$C$6"
The references in the Data ID List should direct the formula to pick up the values in a specific workbook and then a specific worksheet, but instead it's returning the correct address but not the value at the other end of it....
I'm stuck!
Any help would be appreciated, I suspect this is a really stupid error on my part.
Phel x
I seem to be having a blonde moment. The below formula is returning it's own value and not the value of the cell it's directed at. I've tried several fixes for this now and don't seem to be able to identify what's going wrong!
Could anyone offer a suggestion? I think my brain has failed on this.
="'["&('Data ID List'!A2)&"]"&('Data ID List'!B2)&"'!$C$6"
The references in the Data ID List should direct the formula to pick up the values in a specific workbook and then a specific worksheet, but instead it's returning the correct address but not the value at the other end of it....
I'm stuck!
Any help would be appreciated, I suspect this is a really stupid error on my part.
Phel x