Forum Discussion

Copper Contributor

Apr 15, 2025

If cell has any text in it

This is hard to explain I am after a formula to look up cells in the range C6 to AB14. If the cell has text in it i would like it to pull the data from column B and the row it has the text in an...

excel

Formulas and Functions

aquigley1

Brass Contributor

Apr 15, 2025

There might be a simpler way to do it, but what comes to my mind is to use if, isblank, and concatenate. ie "=IF(ISBLANK(A2), "", CONCATENATE(A2,C2)).

In this formula, if the cell in column A is blank, it leaves the cell in column D blank.

If the cell in column A is not blank, it concatenates the value of the cell in column A with the value of the cell in column C.

Am I understanding your question correctly, and does this solve it?

gavinbing
Copper Contributor
Apr 16, 2025
I am only interested in the cells that have text. so a c service or a zur service and the registration and the week it is due.

I am not interested in any blanks if that makes sense
- aquigley1
  Brass Contributor
  Apr 16, 2025
  Right. With that formula, if the reference cell is blank, the output cell will be blank as well. If the reference cell is not blank (has text), it will output the desired values.