Referencing a cell containing a reference formula

[hsandeep]

Thanks to this forum through which I got help & now in my workbook, in Sheet1, in cell address F9, I am able to fill a value present on Sheet2’s cell address M17 using ‘indirect’ function instead of a simple Excel function like F9’=Sheet2!M17’.
In Sheet3, cell H6 I want to do FURTHER REFERENCING such that F the formula needed in H6 should be able to evaluate the cell address to which the formula in Sheet1’s F9 is pointing to (i.e. Sheet2!M17) & then go RIGHT (of Sheet2!M17) by 5 columns & DOWN (of Sheet2!M17) by 4 rows & fill the value of the cell. It would be like instead of directly punching in H6’=Sheet2!R21’, the formula in cell H6 should do this.
Please note: the source cell contains a value which is either numerical or alphabet/(s) or alphanumerical or ‘blank’. The formula should fill the values in case-sensitive form if the sourced value is alphabet/(s) or alphanumerical. For a ‘blank’, the output cell should show a ‘blank’ & not ‘0’ (zero).
What formula should be filled in H6?
I am using Excel 2003 & it runs under Excel 2007 in “compatibility mode”.
Thanks in advance.
hsandeep

 

[hsandeep]

Andrew,
Okay. Many thanks for the help rendered. Have a nice day.
hsandeep