Forum Discussion
Validacion de datos
Necesito cambiar la descripción de una celda automáticamente al seleccionar una opción de una lista desplegable. Como se puede hacer?
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.