BUSCARV arroja =BUSCARV...

%3CLINGO-SUB%20id%3D%22lingo-sub-2620435%22%20slang%3D%22es-ES%22%3EVLOOKUP%20throws%20%3DVLOOKUP...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620435%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I%20have%20a%20large%20table%20where%20I%20am%20using%20VLookup%20to%20get%20data%20from%20another%20table%20in%20another%20sheet%20of%20the%20same%20file%2C%20almost%20all%20the%20VLookup%20work%20correctly%20but%20there%20is%20one%20in%20particular%20that%20when%20I%20put%20it%20and%20give%20the%20fx%20button%20I%20can%20see%20that%20in%20the%20result%20of%20the%20formula%20exactly%20shows%20me%20what%20I%20was%20looking%20for%20which%20is%20%2221428%22%20in%20embargo%20by%20giving%20it%20to%20enter%20instead%20of%20showing%20me%20that%20in%20the%20table%20shows%20me%20the%20formula%20such%20that%20%3DVLOOKUP(.......)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%202%20images%2C%20I%20don't%20think%20it%20could%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2620435%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2621215%22%20slang%3D%22en-US%22%3ERe%3A%20BUSCARV%20arroja%20%3DBUSCARV...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621215%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122268%22%20target%3D%22_blank%22%3E%40Antoniomatas%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20seeing%20the%20document%20that%20you're%20working%20with%2C%20I%20can%20only%20speculate.%20However%2C%20my%20first%20instinct%20tells%20me%20that%20this%20may%20be%20a%20formatting%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola, tengo una gran tabla donde voy usando BuscarV para que me saque datos de otra tabla en otra hoja del mismo archivo, casi todos los BuscarV me funcionan correctamente pero hay uno en concreto que al ponerlo y darle al botón fx puedo ver que en el resultado de la fórmula exactamente me muestra lo que yo buscaba que es "21428" en embargo al darle a enter en lugar de mostrarme eso en la tabla me muestra la fórmula tal que =BUSCARV(.......)

 

Adjunto 2 imágenes, no se que podría ser.

 

Gracias a todos

1 Reply

Hello @Antoniomatas,

 

Without seeing the document that you're working with, I can only speculate. However, my first instinct tells me that this may be a formatting issue.