I am getting #value error in a formula.comparing a text string(using
wildcard) in a column range with a text string(wild card) I want extract row
numbers that matches that string in a range as array formula.While checking
in formula evaluation,to find where I did wrong,I found results are coming
correctly at all steps except final step.At last stage of formula evaluation
I find =if(false,false,true,false,# value,false,true,#value) like this.The
true values are the results what I desire.Then I used the function
if(iserror,.That also didn't work.
Any body please help me to how can I eliminate that # value error.