Home

Vlookup - returned value

%3CLINGO-SUB%20id%3D%22lingo-sub-802471%22%20slang%3D%22en-US%22%3EVlookup%20-%20returned%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802471%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20!%3C%2FP%3E%3CP%3EIs%20there%20somebody%20who%20knows%20if%20it%20possible%20to%20get%20the%20returned%20result%20in%20a%20number%20format%20(example%20%220%22)%20if%20the%20value%20I%20look%20for%20doesn't%20exist%20in%20the%20list%20%3F.%26nbsp%3B%3DVLOOKUP(A2%3BImport!%24A%241%3A%24E%24500%3B2%3BFALCE)%2C%20if%20the%20value%20doesnt%20exist%20the%20answer%20is%20%23Missing%20or%20in%20Swedish%20%23Saknas.%20Later%20I%20use%20a%20pivotable%20for%20calculate%20the%20values%20in%20this%20column%20and%20the%20calculation%20is%20broken%20if%20there%20is%20any%20value%20with%20%23Missing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EFredrik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-802471%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802557%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20-%20returned%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802557%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3DIFERROR(VLOOKUP(A2%2C%3CBR%20%2F%3EImport!A%241%3AE%24500%2C%3CBR%20%2F%3E2%2C0)%2C0)%3C%2FLINGO-BODY%3E
feffes
Occasional Visitor

Hi !

Is there somebody who knows if it possible to get the returned result in a number format (example "0") if the value I look for doesn't exist in the list ?. =VLOOKUP(A2;Import!$A$1:$E$500;2;FALCE), if the value doesnt exist the answer is #Missing or in Swedish #Saknas. Later I use a pivotable for calculate the values in this column and the calculation is broken if there is any value with #Missing. 

 

Regards

Fredrik

1 Reply
Try this:
=IFERROR(VLOOKUP(A2,
Import!A$1:E$500,
2,0),0)
Related Conversations