Aug 14 2020 12:04 AM
Aug 14 2020 03:32 AM
Here is a small demo with one of the possibilities.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Aug 14 2020 09:15 AM
@NikolinoDE tengo una lista de validación de datos y un recuadro con descripción. Quiero que al seleccionar cada opción de la lista, el recuadro cambie la descripción automáticamente .
Aug 14 2020 11:06 AM
Aug 14 2020 10:52 PM
@Omargrajales I believe the classic VLOOKUP function does what you need. Though, it depends on how your data is structured. A combination of INDEX and MATCH or new functions like XLOOKUP and FILTER may also be used, provided that you are a Microsoft 365 subscriber.
I've attached a small file to demonstrate each of the above. All of it can be made more dynamic by using named ranges and structured tables that contain your data, but I didn't go into that for now.