Forum Discussion

Copper Contributor

Mar 09, 2021

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...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Mar 09, 2021

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.

Copper Contributor

Mar 09, 2021

Intenté también cambiando la columna de la 1 a la 2 =BUSCARV(B41,BOLETAS...….,2,FALSO) y sigue marcando el mismo error, en mi referencia SI EXISTE EL VALOR "IMPRESION", pero aparece como si no estuviera

Riny_van_Eekelen
Platinum Contributor
Mar 09, 2021
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).
- DanielaLeCa96
  Copper Contributor
  Mar 09, 2021
  I need to search C40:C45 values in the lookup range, and I need to get the values of the first column in that range, I men, If I put "Impresión" I need to appear "Canon 3900" as a result of the formula
- DanielaLeCa96
  Copper Contributor
  Mar 09, 2021
  Riny_van_Eekelenthis is the lookup value (matriz de búsqueda)
  - Riny_van_Eekelen
    Platinum Contributor
    Mar 09, 2021
    DanielaLeCa96 You are uploading pictures. I saw those. Can you upload the file (without any confidential information).
- DanielaLeCa96
  Copper Contributor
  Mar 09, 2021
  Riny_van_Eekelenthis is my formula

Resources