Hi,
I'm using a vlookup formula, using a description text as the lookup_value. I know it would be better to use some sort of reference number rather than a text description but this is the only unique matching I can do.
The formula works fine for about 70% of the rows, but in the remaining 30% I get a #VALUE! error. I've done some searching on this and other forums and the indicatinon I get is that it should be related to the data type on the lookup_value cell. This is defined as General for all lookup_value cells and for the first column of the table array. In other words if I'm doing the exact same thing for all rows why am I getting an error only in some?
Thanks in advance
I'm using a vlookup formula, using a description text as the lookup_value. I know it would be better to use some sort of reference number rather than a text description but this is the only unique matching I can do.
The formula works fine for about 70% of the rows, but in the remaining 30% I get a #VALUE! error. I've done some searching on this and other forums and the indicatinon I get is that it should be related to the data type on the lookup_value cell. This is defined as General for all lookup_value cells and for the first column of the table array. In other words if I'm doing the exact same thing for all rows why am I getting an error only in some?
Thanks in advance