I want a function that will work like a vlookup function except that it will match exact values in the corresponding cells rather than the closet value. If the value being looked up isnt there i want it to return a zero in that cell. I hope this makes sense. Let me know if it isnt clear enough.

using vlookup with the false option for the range lookup which would give you an N/A if the item is not found. Then wrap it in an if(iserror) function to make the #N/A = to zero.