Hi Curious Dude,

Try this formula,

=IF(AND(NOT(A3=""),B3=""),A1,IF(AND(NOT(B3=""),A3=""),B1,IF(AND(NOT(A3=""),NOT(B3="")),A1& " and " & B1,IF(AND(A3="",B3=""),""))))

paste it in cell h1.