Formato correcto para BuscarV

%3CLINGO-SUB%20id%3D%22lingo-sub-1376146%22%20slang%3D%22es-ES%22%3ECorrect%20format%20for%20SearchV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376146%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%2C%20I%20have%20a%20question%20in%20the%20FindV%20function.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20prevent%20%23N%2FA%20from%20being%20returned%20to%20the%20FindV%20function%20when%20I%20have%20columns%20formatted%20text%20and%20number%20and%20it%20only%20gives%20me%20results%20in%20crosses%20of%20boxes%20in%20text%20format%3F.%20How%20can%20I%20format%20columns%20of%20numbers%20appropriately%20if%20it%20does%20not%20change%20me%20to%20number%20format%20when%20I%20ask%20for%20it%20in%20the%20tools%3F.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1376146%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377642%22%20slang%3D%22en-US%22%3ERe%3A%20Formato%20correcto%20para%20BuscarV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661682%22%20target%3D%22_blank%22%3E%40Rafa_Alcantara1%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20familiar%20with%20FindV%2C%20however%2C%20most%20formulae%20can%20be%20wrapped%20in%20an%20IFERROR%20function%2C%20in%20order%20not%20to%20show%20resulting%20errors%20(or%20indeed%20to%20display%20an%20alternative%20to%20the%20error).%26nbsp%3B%20See%20below%20example%20using%20the%20FIND%20function%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(FIND(%22TEXT%22%2CA1%2C1)%2C%22%22)%3C%2FP%3E%3CP%3E...%22%22%20displays%20a%20blank%20cell%20where%20the%20formula%20results%20in%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(FIND(%22TEXT%22%2CA1%2C1)%2C%22Check!%22)%3C%2FP%3E%3CP%3E...the%20text%20'Check!'%20is%20displayed%20where%20the%20formula%20results%20in%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Buenos dias, tengo una duda en la función BuscarV. 

Como puedo evitar que me devuelva #N/A la función BuscarV cuando tengo columnas con formato texto y número y solo me da resultados en los cruces de casillas con formato texto?. ¿Como puedo dar el formato adecuado a columnas de números si no me cambia a formato número cuando lo pido en las herramientas?. Gracias.

1 Reply
Highlighted

@Rafa_Alcantara1

 

Hi,

 

I'm not familiar with FindV, however, most formulae can be wrapped in an IFERROR function, in order not to show resulting errors (or indeed to display an alternative to the error).  See below example using the FIND function:

 

=IFERROR(FIND("TEXT",A1,1),"")

..."" displays a blank cell where the formula results in error

 

=IFERROR(FIND("TEXT",A1,1),"Check!")

...the text 'Check!' is displayed where the formula results in error