#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
You could try-
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.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Combination function | sanasath | Excel | 0 | 12-13-2005 07:24 AM |