Mar 09 2021 09:34 AM
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 matriz de búsqueda, podrían ayudarme a solucionar este problema con más posibilidades de error.
ADJUNTO ER ERROR DE LA FÓRMULA Y LA TABLA / MATRIZ DE BÚSQUEDA
Mar 09 2021 09:48 AM
@DanielaLeCa96 I believe your lookup range is incorrect. B41 contains "Impresion". So the first column in your lookup range should also include "Impresion". If not, your formula (VLOOKUP in English) will not find a match and returns #N/A.
Mar 09 2021 09:54 AM
Mar 09 2021 10:03 AM
@DanielaLeCa96 Not sure if the translation I get is entirely clear, but it seems that your lookup range a from A27 to B32 where the lookup value seems to be in the 2nd column. If you swap the columns (thus move A to the right of B) so that "Impression" is in the first column and you look for the 2nd columns you will get "CANON 3900" as the result. Is that what you want?
Alternatively, look into the use XLOOKUP (don't know the Spanish name for it, sorry).
Mar 09 2021 10:28 AM
@Riny_van_Eekelenthis is my formula
Mar 09 2021 10:29 AM
@Riny_van_Eekelenthis is the lookup value (matriz de búsqueda)
Mar 09 2021 10:32 AM
Mar 09 2021 10:36 AM
@DanielaLeCa96 You are uploading pictures. I saw those. Can you upload the file (without any confidential information).
Mar 09 2021 10:48 AM
Mar 09 2021 11:14 AM
@DanielaLeCa96 Precisely. That's what I suggested in the beginning. :)
Feb 09 2023 02:15 AM
Thanks a lot, you problem resolved, resolute my problem