=isblank returns cell as appearing blank, but not with a blank value resulting in #REF

Hi, I hope this is the right place to post this question - and i hope its not one out there with an answer already - Ive had a good look around without much success so have decided to take the plunge and try and explain my question!

The problem has come about through building up something of a chain of cells relying on the entry in another

Cell A1 on sheet 1 refers to a cell on Sheet 2 ( Sheet2!B2 ) - and if B2 on sheet one is blank - Sheet 1 A1 appears blank itself.

However - A2, A3, A4 A5 ect on Sheet 1 also refer to Sheet 1 A1, and the value of cell A1 directs these cells to a different work sheet

For example

Sheet 2 B2 Value is 'Dogs'

Sheet 1 A1 Appears 'Dogs'

Sheet 1 A2 Then Looks at the work Sheet 'Dogs' Cell C3

And i have used this formula (For the purposes of relating the target cell in comparison the position of the cells however i have actually changed from the standard A1 grid format to R1C1 format)

=IF(ISBLANK(RC[-1]),"",INDIRECT("'"&(RC[-1]&"'!c3")))

This works fine when the original target cell has a value (Sheet 2 B2),

however when this is blank, And Sheet 1 A1 Appears Blank - it keeps returning the #REF

I have tried using =IF(RC[-1]="","") - which has worked to return a blank cell - but i cannot work out how to complete this formula with my 'indirect' formula


Sorry it has been so wordy - i have not found it easy to explain

Many thanks in advance to anyone who can help me!


Ben

Thank you!

I think its been a very long day - closest i came up with was

=IF(RC[-1]="",""),INDIRECT("'"&(RC[-1]&"'!c3"))

i just couldn't quite get the brackets right

Thank you so much for your help - and really quick reply!!!


Ben

Thanks for your help - was ahead of you on the reputation thing - and did look for the thread tools button, but couldnt see it last night - have found it now - thanks for your help and patience