Forum Discussion
Help needed: extracting text if present in cell otherwise jump to the next one
Hello everyone, I am having trouble to fullfill a simple task. I have text in column A,B,C but not necessarly in all of them. If there is text in column C then it should be shown, if not jum...
Hi NickS1655
if I understand you right, you want to select from right column to left column. Then this could be a solution:
=IF(C1<>"",C1,IF(B1<>"",B1,IF(A1<>"",A1,"nothing found")))