On 2002-04-24 16:21, Parra wrote:
I am doing a vlookup function and I sum the results. But how do I get the vlookup function to display "0" if there is no value for what it is looking for. I was trying to do a if function but it didn't work. Any suggestions. Thanks
On 2002-04-24 16:21, Parra wrote:
I am doing a vlookup function and I sum the results. But how do I get the vlookup function to display "0" if there is no value for what it is looking for. I was trying to do a if function but it didn't work. Any suggestions. Thanks
On 2002-04-24 16:31, Mark W. wrote:
Or, have and additional column containing the formula, =IF(ISNA(A1),0,A1), where A1 contains your VLOOKUP. You may choose to hide column A so that viewers of the worksheet are oblivious the the presence of #N/A errors.
On 2002-04-24 16:34, Aladin Akyurek wrote:
On 2002-04-24 16:31, Mark W. wrote:
Or, have and additional column containing the formula, =IF(ISNA(A1),0,A1), where A1 contains your VLOOKUP. You may choose to hide column A so that viewers of the worksheet are oblivious the the presence of #N/A errors.
I bet COUNTIF will be as fast as that & will not waste space/memory.
On 2002-04-24 16:36, Mark W. wrote:
On 2002-04-24 16:34, Aladin Akyurek wrote:
On 2002-04-24 16:31, Mark W. wrote:
Or, have and additional column containing the formula, =IF(ISNA(A1),0,A1), where A1 contains your VLOOKUP. You may choose to hide column A so that viewers of the worksheet are oblivious the the presence of #N/A errors.
I bet COUNTIF will be as fast as that & will not waste space/memory.
Time vs. Size -- the classic worksheet design tradeoff! It all depends on the size of the table array and the average successful hit rate.
On 2002-04-24 16:44, Parra wrote:
I would to use Yogi's formula because I feel I won't have to do much but I get an error message, any suggestions?
Thanks