Forum Discussion
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...
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
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.