Hi Andrei,

In that case I don't understand what you're trying to do or, more importantly, why.



I explained that the N() function extracts the value from the cell in my previous post. In cell K2 you had a formula which was working already and it returns the value 1, which is what I amended your other formula to do. They match.

If you don't want to return the value, what do you want to return - the address? If so, why is the address useful to you and why don't you just concatenate the strings in cells F2:J5?