Aug 13 2019 05:41 AM
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
Aug 13 2019 06:20 AM