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...
maybe something like:
=IF(C6:ZZ15="", "", $B6:$B15 & " - " & C$3:ZZ$3 & " - " & C6:ZZ15 )if you want them all in a column you could wrap with TOCOL()