Forum Discussion
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 You are uploading pictures. I saw those. Can you upload the file (without any confidential information).
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!
Thanks a lot, you problem resolved, resolute my problem
DanielaLeCa96 Precisely. That's what I suggested in the beginning. 🙂