Hi,

I am trying with the below formula to settle my problems, however, i always get #N/A.

{=INDEX('Site Detail'!$A$11:$A$500,MATCH(1,('Site Detail'!$B$11:$B$500<>"")*('Site Detail'!$B$11:$B$500=MID(K3,FIND("_",K3,1)+1,6)),0))}

I would like to enter KCN003 instead of A41_KCN003_2G1i.

Please kindly advice.