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