Hey guys,

I'm stuck on this formula I'm trying to do.

I'm using something like this:

INDIRECT("'"&A1&"'!"&B1)

I put name of the sheet from where I want to pull information in A1 in sheet where is the formula(lets say sheet1), lets say A1=sheet2. All good so far. I want to put cell reference in B1 in the sheet1 (lets say B1=D3).

My problem is that this formula takes value from Sheet2 and B1 in sheet2. I want this formula to take values from sheet2 ( as per value in A1) and whatever is in sheet1B1 (D3 in this case).


So right now I end up with Sheet2B1 but i would like to end up with Sheet2D3.


I hope this is not too confusing but I cant figure this out and I would really appreciate any help.

Thank you in advance.

Jakub