Help needed: extracting text if present in cell otherwise jump to the next one

Question

Hello everyone,&nbsp;&nbsp;I am having trouble to fullfill a simple task.&nbsp;I have text in column A,B,C but not necessarly in all of them.&nbsp;If there is text in column C then it should be shown, if not jump to column B and check here.&nbsp;&nbsp;The if() formulas I have build do not work and even the isblank() formula is not helping, as the IF() function won't recognize "TRUE" and "FALSE".&nbsp;&nbsp;I hope someone can help&nbsp;Thank you very much&nbsp;&nbsp;

martin_weiss · Answer

Hi&nbsp;NickS1655&nbsp;&nbsp;if I understand you right, you want to select from right column to left column. Then&nbsp; this could be a solution:&nbsp;=IF(C1&lt;&gt;"",C1,IF(B1&lt;&gt;"",B1,IF(A1&lt;&gt;"",A1,"nothing found")))&nbsp;&nbsp;&nbsp;

Forum Discussion

Help needed: extracting text if present in cell otherwise jump to the next one

1 Reply

Resources