Vlook Formula Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2348440%22%20slang%3D%22en-US%22%3EVlook%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348440%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20experts.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20simple%20Vlookup%20formula%20in%20attachment.%20Formula%20gives%20%23N%2FA%20as%20a%20result.%20As%20I%20understand%20it%20is%20not%20possible%20to%20search%20in%20cell%20if%20cell%20size%20is%20more%20than%20255%20symbol%20.%20The%20point%20is%20the%20formula%20works%20normally%20in%20my%20mates%20computer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20solve%20this%20issue%3F%20Any%20idea%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348440%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi, experts. 

Please find simple Vlookup formula in attachment. Formula gives #N/A as a result. As I understand it is not possible to search in cell if cell size is more than 255 symbol . The point is the formula works normally in my mates computer. 

 

How can I solve this issue? Any idea?

 

 

1 Reply

@IBM_Design 

Try this formula:

 

=INDEX(Progress[For Refcode],MATCH(TRUE,INDEX(ISNUMBER(FIND([@[Search for]],Progress[Design Drawing])),,),0))