Lista desplegable desde constantes bidimensionales

%3CLINGO-SUB%20id%3D%22lingo-sub-2106907%22%20slang%3D%22es-ES%22%3EDrop-down%20list%20from%20two-dimensional%20constants%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106907%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I%20want%20to%20create%20a%20drop-down%20list%20from%20a%20two-dimensional%20constant%20associated%20with%20a%20name%2C%20for%20example%20the%20name%20of%20the%20constant%20%22listed%22%20and%20the%20constant%20would%20be%20for%20example%20%22x%22%3B%22%20and%20%22%3B%22%20z.%22%20then%20from%20a%20drop-down%20list%20associate%20the%20name%20%22listed%22%2C%20but%20you%20get%20the%20following%20error%3A%20%22The%20source%20currently%20evaluates%20an%20error%22%2C%20does%20anyone%20have%20a%20solution%3F%20or%20is%20it%20not%20possible%20to%20associate%20a%20two-dimensional%20constant%20with%20a%20drop-down%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106907%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2107349%22%20slang%3D%22en-US%22%3ERe%3A%20Lista%20desplegable%20desde%20constantes%20bidimensionales%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2107349%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F946492%22%20target%3D%22_blank%22%3E%40ypalmado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20you%20to%20post%20a%20spreadsheet%20containing%20an%20example%20and%20how%20you've%20tried%20to%20address%20it%3F%20Your%20description%20by%20itself%20is%20a%20good%20start%2C%20but%20still%20hard%20to%20grasp.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2327323%22%20slang%3D%22es-ES%22%3ERe%3A%20Drop-down%20list%20from%20two-dimensional%20constants%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2327323%22%20slang%3D%22es-ES%22%3Ewhat%20is%20intended%20is%20to%20create%20a%20drop-down%20list%20in%20a%20cell%20using%20data%20validation%20and%20assign%20a%20list%2C%20but%20this%20list%2C%20rather%20than%20being%20associated%20with%20a%20range%20of%20cells%2C%20should%20be%20associated%20with%20a%20one-dimensional%20constant%2C%20previously%20assigned%20to%20a%20name.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20for%20example%2C%20in%20cell%20A1%2C%20in%20data%20validation%20I%20assign%20you%20a%20list%2C%20and%20this%20list%20must%20be%20the%20name%20of%20the%20estado_1%2C%20which%20has%20a%20one-dimensional%20constant%20of%20%22est1%22%3B%22%20est2%22%3B%22%22%20est3%2C%20so%20that%20at%20the%20time%20of%20displaying%20the%20list%20you%20can%20select%20the%20constants%20in%20that%20name.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2327590%22%20slang%3D%22en-US%22%3ERe%3A%20Lista%20desplegable%20desde%20constantes%20bidimensionales%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2327590%22%20slang%3D%22en-US%22%3EPlease%20forgive%20me%2C%20but%20I'm%20going%20to%20repeat%20what%20I%20asked%20the%20first%20time%3A%20%22Is%20it%20possible%20for%20you%20to%20post%20a%20spreadsheet%20containing%20an%20example%20and%20how%20you've%20tried%20to%20address%20it%3F%20Your%20description%20by%20itself%20is%20a%20good%20start%2C%20but%20still%20hard%20to%20grasp.%22%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

hola, deseo crear una lista desplegable a partir de una constante bidimensional asociada a un nombre, por ejemplo el nombre de la constante "listado" y la constante sería por ejemplo ={"x";"y";"z"}. luego desde una lista desplegable asociar el nombre ="listado", pero aparece el siguiente error: "el origen actualmente evalúa un error", alguien tiene una solución? o no es posible asociar una constante bidimensional a una lista desplegable?

3 Replies

@ypalmado 

 

Is it possible for you to post a spreadsheet containing an example and how you've tried to address it? Your description by itself is a good start, but still hard to grasp.

lo que se pretende es crear una lista desplegable en una celda utilizando validación de datos y asignar una lista, pero esta lista, en lugar de estar asociada a un rango de celdas deberá asociarse a una constante unidimensional, previamente asignada a un nombre.

por ejemplo, en la celda A1, en validación de datos le asigno una lista y esta lista debe ser el nombre = estado_1, el cuál tiene una constante unidimensional {"est1";"est2";""est3"}, para que al momento de desplegar la lista pueda seleccionar las constantes en ese nombre.
Please forgive me, but I'm going to repeat what I asked the first time: "Is it possible for you to post a spreadsheet containing an example and how you've tried to address it? Your description by itself is a good start, but still hard to grasp."