String to name
 

How to convert the value to name where
IF(K2=CONCATENATE("label",a2,"_start"), "OK","Failed")

name value
1) label20_start
2) label30_start
3) label40_start
4) label50_start
5) ....

a2 is a cell where
cell a2 value = 20
cell a3 value = 30
cell a4 value = 40
cell a5 value = 50
......

String to name
 

Where fx CONCATENATE("label",a2,"_start") will evaluate as
IF(K2= label20_start, "OK","Failed")

if K2 = 09/10/2006 or K2 = 10/10/2006, the above formula will give "OK"
value, but I keep on getting Failed
e.g label20_start = 09/10/2006

"crapit" wrote in message
...
How to convert the value to name where
IF(K2=CONCATENATE("label",a2,"_start"), "OK","Failed")

name value
1) label20_start
2) label30_start
3) label40_start
4) label50_start
5) ....

a2 is a cell where
cell a2 value = 20
cell a3 value = 30
cell a4 value = 40
cell a5 value = 50
.....

String to name
 

=IF(K2=INDIRECT("label"&A2&,"_start"), "OK","Failed")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"crapit" wrote in message
...
How to convert the value to name where
IF(K2=CONCATENATE("label",a2,"_start"), "OK","Failed")

name value
1) label20_start
2) label30_start
3) label40_start
4) label50_start
5) ....

a2 is a cell where
cell a2 value = 20
cell a3 value = 30
cell a4 value = 40
cell a5 value = 50
.....