Moving Text With Function

[keats1821]

I've been trying to do this and I don't know if it's even possible. I need to move one string of text from one place to another (e.g., the words "Severed Connection" (located in A1) to B3. I can do that with the REPT function (probably not the best way, but it worked for those purposes). The thing is that the B column contains a list (i.e., B1 = 0, or Blank Cell; B2 = 0, or Blank Cell; B3 = Severed connection (or other text); B4 = 0, or Blank Cell etc.). I need to return the actual text (e.g., Severed, from the above example) from the range (B1:B4) in another cell (E1).


I need it this way because A1 will constantly be changing, as will the values in the B column (e.g., when A1 changes, B2 may become "Connection Positive" and B3 may become 0, or be blank; thus, E1 will have to show Connection Positive). I may be asking too much here. Is anything like this possible?