Need help on what function to use???
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.
|