Retrieving data from other worksheets by specifying worksheet and sheet names w/o VBA

Hi all

I need such formula, that if I write in A1 another worksheet's name(for example worksheet2) and in A2 it's sheet's name (for example sheet1) formula will return value of A3 cell from sheet1 worksheet2.

I don't want to use VBA, and I want to do this without opening of worksheet2. (So I can't use INDIRECT function)

Can somebody help?

Thanks for your time

Re: Retrieving data from other worksheets by specifying worksheet and sheet names w/o

StephenR

Quote

Not sure what you're asking. Sheet1 worksheet2 - do you mean workbook?

yes, I meant workbook when i wrote worksheet. It's my mistake.

Re: Retrieving data from other worksheets by specifying worksheet and sheet names w/o

StephenR

Quote

I don't think this is possible if you are excluding VBA.

Yes you are right as I found out. It's not possible.

Thank you for reply