I have a form that I use that collects numerical data from several operations. I use lookups to bring that data into another worksheet. My problem is that not all values I search for are always present.
Is there a way to have the lookup return a "0" instead of the "#N/A" error if the value I am looking up is not present?
I thought that I had seen this posted here before, but I have been unable to find it.
Is there a way to have the lookup return a "0" instead of the "#N/A" error if the value I am looking up is not present?
I thought that I had seen this posted here before, but I have been unable to find it.