How to assign a flag based on the values of a Named Range?

[feipezi]

Hi,

Suppose I have a Named Range called "data": $a$1:$e$10. What I want is if any of cells of "data" bears a value of 10, a character of "*" will be put in Column("f") in the same row. I used an Array Formula but it's not working.

{=IF(data="10","*","")}

Any input share with me?

Thanks in advance.

 

[SkipVought]

hi,

in F1...
[tt]
F1: =if(isna(match(10,A1:E1,0)),"","*")
[/tt]
copy/paste thru your rows of data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[feipezi]

Hi Skip,
I tried it. But if I use quotes on 10, then all the cells populated with "*", if not, then none has "*".

BTW, are you saying I don't need Array Formula, just the regular one, am I right?

Please advise.

Thanks again.

 

[SkipVought]

But if I use quotes on 10,

is your lookup value in your range a TEXT value or is it a NUMERIC value?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

No array formula.

The Named Range is irrelevant.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[feipezi]

Thanks Skip, I got it. You're right: no Array Form. and no Named Range.

You're the man!

 

[SkipVought]

and you got rid of the QUOTES?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[feipezi]

Yes, Skip. I got rid of the quotes.

Thanks again.