Hi Experts,

Is there a formula/macro that I can apply to the results of a Vlookup
function(=VLOOKUP($A$6:$A$119,Swe_Lookup,2,FALSE)) to replace the "Value Not
Available Error" (#N/A) error with a 0?

I am running Excel Pro on Windows XP Pro SP 2.

I very much look forward to hearing from you.

kind regards,

Paul