Om du vill att excel skall förstå att en text är en adress så får du använda
INDIREKT()
https://support.microsoft.com/sv-se/o...
exempel. Om du har skrivit texten "A1" (utan citattecken) i cell A2 och skriver formeln =INDIREKT(A2) i cell A3
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMYAAACZCAYAAAB0Q0V/AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAArISURBVHhe7d1faFNZHgfw39UH8Q/4poKCRJs8LHfdh1ncafMgpGuL9mHawAyzLENnodt0cMuU7jphhsq+OA/ZLtriCsbp464P8xD3pS0W7OpDZ1nXcdGNgk1oWrBgRaSC+A80c34nJ+3NzUmb2tzkNH4/EHLvyZ+mer/3nN+9ObdWViAAKLBJ3QOAA4IBoIFgAGhYt27dQo0B4GKl02kEA8DFmp+fRzAAXKyFhQUEA8DFevz4MYIB4GI9efIEwQBwsRYXFxEMABecxwDQsG7fvm1kj7Ft2zbasWMHbd++nd6+fataiz19+pRevHhBr169Ui0A62fslwjfvHlDDx8+pJcvX9KuXbu04eDHN2/eTHv37qWtW7eqVoD1M/7btfPz83Ljd2/43FO8fv2aGhoaVAtA5RhfY+zZs4eePXum1pbx8Il7CgAvGB8M7i2eP3+u1pZxTYHhE3ilJsH48ceb9MUXPfTZZ7+V9wCmqXowOBTffPM1ffrpb6i5+dd0585tmp6eVo8CmGFNwXjw4AFdv35drb2boaGz1NjYSEeOHKHPP/8dTU39mwKBgHoUwAxlB4NDcefOHTp48KBqWbvz5/9GMzMzdPjwr1SLGSajfvJHJ9WaWvdHabklJzPS4XhehkY6+HmOW0eURiYz6vGcwvcufk1HdES0Lsv97MJb/uX8WMeI49mZEeqQj2s+S/7Wsfz+/Pkdv6aiXut4Xk5G/Dzx+6r3Kfyc/JoOcn6UelNWMPKhOHToEO3bt0+1lo8DEQw20qVL/5Dr3357WraZLUGR4q2oiB2doFQqJW4TNNFLNBpp0Wx8hZZeMxGnQCJG/a4tbPk9c7dYSD1QQGyc/TEi8dxYyEddl9XzJ6JkU5ji+ddf7iKffP4kXYgFqNX9XpmrNJq0xWtG6arjY2RG+imSCFB8gt9ngtqmnZ/TR81tRLELq//7bFSrBmO9oWAnTvxBDplYY2OTXOY2k9nhMNmJc2vYK/rIF4rRmahNiXPuvW8JvhD1iOcnU2X/kCWT0RaKBeJ0uSu32a9q8golwq1UnItRSoZ7qTeQpFFHMjKppAhoD4nMCRwE8TlHry79Xj6RDDtxpahXrRcrBqMSocjL1yY+X+4/8tGjR7KNi3HGBfjY2KhcrrjJaOHwQtxW7Qz8PWIjF3vF/jI3ckVuMMnCvW+l8ZAokhC9gr4r0Zq8kiDb7w5Rhq6OJiksupFQa7hgww/FUsWhCxxQvY/ga6Y2O0FX6jQZJYNRyVCwZPL/8t62fy7vr1+/RiMjF+URKg5Ib+8JOcTKB6WixJ7cOTThWznblK+rl8LJGK1pxOA7QAFKUlmdQIaHN7kN0ykZa3GE2FXrpC5QbgQVK9r7l5ahmWnerl0buhxGhXPDq1Cr+F1LBToXoMJg+ehAQOzQZjzcA9SQNhiVDgVLJpPyno9GsY8//oROnfqzPKs9PHyWzp07L4dYH3zwS/l4Rb1LjyGFKBYPUyJSXIivx9KG3xKhaVkjqAeUwhrDFQDxOg6ec9izugylRB3h7jByw6j88CpErWH9+8phG0XpTLnDtjqwiUPg5EUoGJ+v4PrCiQ/T7t69W7Z7esj2HXsMSbw2Hi6vEJcyMzQtStmiUYuDs2BvG20pPNK0qmaKiQKbRLjK/Uh6uV5ApH5pZxFJiNA6hlNsadi2VMS/HzZxCPLh8CoU+frCtm15n8d1xcLCggyNyUI9UVmIX0iphhXIvbDdRs1lbUU+6uotHNuXxdeVK/LX05Opo1FRedQpf4sXDKc4FC2xAMXdvdZ7YBOHgMNw9+5dT0LBbtz4j7xvagrK+/yZ7rNnz1B7e4c8t8G1hbGHcOWGKHauidxwsJSMGLL1c83Qu4a964pj+9J8XZdzPVnR+QcdH/ntwrpHH+Dc83g4tRSKkrVMibqlTmziEHAY5ubmPAkF4x7h0KFfLA2XOBCtrUcpFArRRx+1yzYuvI8ebZHLJvJ1nSGxky7iLJRbzhG1xYtrhpUtb4x5hcV36XooFOM9fPF5kGLuQlkV023NrgDnD8v2y4DLczkty5+j8ECAvm6pGzwfw0v379/PNjV9mL127ZpqybXdvPlftZaVy3wZn1J4liHPTXfeuA3W4OpX2Yb277IzanXdZr7Ltlfy/QxT1pnvteKhEvcIPDy6dOnvcriUPxrFuOdwHn3iZZ6lBx4K9VDUdXZ7PSYvxET36O5x6ocnwWA8V5u/MLh9+w46efIr1Qq1w4V+mxgBVSIZ/B71ffjW4m5DLRuLDwrs379freXkayIAL3jWY1QKXxSBrxjitmXLFjm9FcALxgeDrwTCl9Fx42mt/H0rAC8YGwzuKfgKIXz5HK5X3Hbu3Ckf4yEVeg6otLq44BpfRkd3wQSAd4Vr1wJoGF9jANQCggGggWAAaCAYABoIBoAGggGgYc3NzeFwLRhrcXGx6Hty1YAeA4y20sldLyEYYDQEA0ADwQDQQDAANGoTjBsIBpgNPQaABoIBoIFgAGggGAAaCAaABoIBoIFgAGggGAAatQnGYQQDzIYeA0ADwQDQqFUwLN8fWzCDD4z2v1Pfq6XqQTDAeH/58PdqqXo2xN/HgPcXX7Qbc74BDIFgAGggGAAaCAaABoIBoIFgAGggGAAaCAZUx3iErOAwpdVqejhIVmS8dHuN4QQfVEmahoN+ujeQpbh/mIL+ezSQjdOxku05tTrBh2BA9aTFht95j2z7IlG7CEJ+6y/VLiAY8F4Yj1h0PNlNY1PLvQIr1Y6vhED9Ez3D6Yvd1G0n6fRwvqoQSrXXEvcYAN5LZYeaKNs9xstj2W5qyg6lVmrPmZ2dVUvVhWBAVaSGmrKU2/olud40lB0r0Z7PRq2CgRoDjIYaA8AgCAaABoIBoGFxcaOWAUBB8Q1GQ/ENYBAEA0ADwQDQQDAANBAMqD3+2rkVJFO+P8gQDKip9DjPxeijH9S6KRAMqKFxGjx9jwYGhqhJtZgCwQBviWFSJGiRJYZKlmVRMLI8v5voGMV5YpJfrRoEwQAPpWl48HuiAZ7eMCVuKfok2UeDtb/WwaoQDPBQA30Zn1qaw50WXUXAJkpOG1Rll4BggKfS4xEK8hAqGKHBwUE6nVQPGA7BAO+I+qLzOI+ksjQlaol4PE4DosfYCBAMqJ70OP3zolo2HIIB3mn4kga6k3RcDqWCFBwk+lm3eozJE3sWWX4+j/ED9fn56FWETKjN8bVzMBq+dg5gEAQDQAN/zhg2hJm/XlFL1YFgwIbwr97qHs5C8Q1GO/CnVnlf7R4DNQaABoIBoIFgAGggGAAaCAaABoIBoIFgAGggGFAdG+zvfCMYUB3HTtIQqfnePIGpz6YxnvNaqr3GcOYbqofnX6zx73zjzDfUP564JDb+i8luand2CqXaawjBgOoRPcNG+TvfCAZUSZqGO/vIHuOLIgyQ3deprlVbqr22EAyoivRwJ/XZY6p+OEYnh4j6OodpvER7rbOB4huMVqviG8EA0EAwwEj5nsKpmr0GagwADcz5BuNwz6DrMao57xvBAOOUCkY1h1KoMcBICAbACnCJTgCDIBgAGggGgAaCAaCBYABoIBgAGggGgAaCAaCBYABoIBgAGggGgAaCAaCBYABoIBgAGggGgAaCAaBhzc7OYqISgAtm8IHRMIMPwCAIBoAGggGggWAAaCAYABoIBoAGggFQhOgnF4Tx1BVU8GYAAAAASUVORK5CYII=)
så kommer formeln i cell A3 att returnera värdet i A1. Begripligt?
I ditt exempel är det marginelt krångligare eftersom du vill klistra ihop en adress
Börja med att klistra ihop så adressen (texten) ser rätt ut. Det här borde funka, med ' ' runt fliknamnet:
=SAMMANFOGA("'";E2;"'!A1:B20")
Kompaktare, men kanske mer svårläst:
="'"&E2&"'!A1:B20"
om du testar att petar in din textsträng i INDIREKT() så får skall du få ut matrisen från valt blad:
=INDIREKT(SAMMANFOGA("'";E2;"'!A1:B20"))
Så det kan du använda i din letarad
=LETARAD(A5;INDIREKT(SAMMANFOGA("'";E2;"'!A1:B20"));2;0)
eller, med kompaktare sammanslagning av texten:
=LETARAD(A5;INDIREKT("'"&E2&"'!A1:B20");2;0)