String to name

[crapit]

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
......

 

[crapit]

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

 

[Bob Phillips]

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


--
HTH

Bob Phillips

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