Forum Discussion
DanielaLeCa96
Mar 09, 2021Copper Contributor
ERROR #N/D EN FÓRMULA BUSCARV
Tengo un problema con el resultado de mi fórmula, he leído que el error #N/D aparece cuando la matriz de búsqueda no contiene el valor que buscamos, ya lo revisé, y el valor si está presente en mi ma...
DanielaLeCa96
Mar 09, 2021Copper Contributor
I solved the problem!!
The problema was in the range of the lookup, the value that I need as a result, has to be next to the value that I'm looking for,
I was searching "Impresión" that was in te column B, and I want as a Result a value in the column A, so I put them backwards, Impresión in the column A and the value that I wanted as a Result in the column B and THAT'S IT!
The problema was in the range of the lookup, the value that I need as a result, has to be next to the value that I'm looking for,
I was searching "Impresión" that was in te column B, and I want as a Result a value in the column A, so I put them backwards, Impresión in the column A and the value that I wanted as a Result in the column B and THAT'S IT!
samirsese
Feb 09, 2023Copper Contributor
Thanks a lot, you problem resolved, resolute my problem