What I am trying to do, is lookup cells in a different sheet. Using cell values, to make up the name of the sheet I am trying to use.
On sheet 1 the database in cells A1=A A2=B B1=C B2=D (all values being text)
Ok now my 2 sheets besides the database are called A@C and B@D.
Now normally you would use ='A@C' to ref the respective sheet. What I want to do is use the values in cells A1 and B1, in place of the A and C. So in my mind it would look like ='A1@B1' for A@C and ='A2@B2' for B@D. Obviously it isnt quite that simple or I wouldn't have a question. Please any help here would be appreciated and save me many hours.