ShunNakamura
05-08-2007, 03:36 AM
<span style="color:#FFCCFF">
Note... I am using Excel 2003 for this.
I am in a situation here where I have a table. I want Excel to look through a column of data for a particular value(which will be inputed). If it finds a match I want the match price printed out. That is fine.
My issue is when there is nothing found. I want it to say it is a "Non-standard stock item" if it isn't found.
Now it doesn't sound hard to me but I can't find the appropriate functions in excel to do it.
Basically all I should have to do is to compare the returned value to null. If it is null it should display "Non-standard stock item", if it is not null it should display the price of the value it found.
What I can do. The VLOOKUP to search for, locate the value, and then to print the price is easy. But how do you, in Excel, use an if statement to compare to the null value. All I have managed to find is references saying that Excel does not support a true null value. If that is the case, is there a workaround? I have yet to find it on google or in excel's formula list but I will continue looking(if I am lucky I may find it before anyone responds!)
Edit- I am aware of Excel's ISERROR function but that seems a bit of a sloopy way to try and see if the value is null or not... is it my only option?
</span>
Note... I am using Excel 2003 for this.
I am in a situation here where I have a table. I want Excel to look through a column of data for a particular value(which will be inputed). If it finds a match I want the match price printed out. That is fine.
My issue is when there is nothing found. I want it to say it is a "Non-standard stock item" if it isn't found.
Now it doesn't sound hard to me but I can't find the appropriate functions in excel to do it.
Basically all I should have to do is to compare the returned value to null. If it is null it should display "Non-standard stock item", if it is not null it should display the price of the value it found.
What I can do. The VLOOKUP to search for, locate the value, and then to print the price is easy. But how do you, in Excel, use an if statement to compare to the null value. All I have managed to find is references saying that Excel does not support a true null value. If that is the case, is there a workaround? I have yet to find it on google or in excel's formula list but I will continue looking(if I am lucky I may find it before anyone responds!)
Edit- I am aware of Excel's ISERROR function but that seems a bit of a sloopy way to try and see if the value is null or not... is it my only option?
</span>