I have one sheet with a list of information. First cell is 1,2,3,4,... etc. Then I have multiple sheets looklike form and I need to get information from that first sheet. All other sheets are named 1, 2,3 etc. so sheet 1 should get information frome row 1.
I can get sheet name using formula =RIGHT(CELL("filename");LEN(CELL("filename"))-FIND("]";CELL("filename"))) but if I use that in VLOOKUP, for example =VLOOKUP(RIGHT(CELL("filename");LEN(CELL("filename"))-FIND("]";CELL("filename")));'Sheet1'!A:Z;7;FALSE) i recieve #N/A. What's wrong? If I use =VLOOKUP(A1;CELL("filename")));'Sheet1'!A:Z;7;FALSE) I recieve data correctly.
I can get sheet name using formula =RIGHT(CELL("filename");LEN(CELL("filename"))-FIND("]";CELL("filename"))) but if I use that in VLOOKUP, for example =VLOOKUP(RIGHT(CELL("filename");LEN(CELL("filename"))-FIND("]";CELL("filename")));'Sheet1'!A:Z;7;FALSE) i recieve #N/A. What's wrong? If I use =VLOOKUP(A1;CELL("filename")));'Sheet1'!A:Z;7;FALSE) I recieve data correctly.