Vlookup problems

I am trying to use Vlookup to create some calculations for some data, but the lookup value, is not always used, so I get  the #N/A error. I use a lookup which searches three separate sheets for a sp...