Several ways you can do this, it really depends on how much work you want to put into it.

1 - You can create an "if" loop and return the result as a vector for each iteration.

2 - Turn the operation into a function.

3 - Use the operation as is, then copy it and paste it lower on the sheet to reuse it. Only convenient if you use it a few times only.

See attached example

Kind of hard to follow, but the first thing is seems like you are trying to define a function "PROPERTY(Connect):=BS". What is in the parenthesis is the variable, but that variable is not in the function. "BS" is also undefined. So this doesn't do anything at all.

Then you use "Connect" in the next part, but it is undefined, so there is an error. This part tries to match what is in the "Connect" variable to some numbers, "BS-20" for example. But you will never get a match because the data you imported is in a different format, "BS-20(B )" for example.

You define "Connect" at the end and use it in this function. The function variable should be different. Define it as "PROPERTY(x):= x*3" For example. BS needs to be defined, otherwise include another variable in the function "PROPERTY(x,y):= x*3-y^2". Then you can use it later on as intended "PROPERTY(Connect,BS)= "

Save yourself some complexity and import the data starting from cell C2 instead of C1, this will simplify your loops and matrix indexing.

Before moving on to see if this will work, the above has to be addressed first.