how to have one cell copy to another based on condition

Hi everyone. I'm trying to set it up so that if a particular cell has any data in it, the contents of a different cell get sent to another. I want the no data/data to serve as a trigger.

As an example, if I put anything into cell A3, I want the contents of cell A1 to copy to H1. I'd also like it to be dynamic so that if I put something into cell B3, the contents of B1 get copied to H1, etc.

I'm afraid I don't follow your logic. So anything is in column A, you want A1=H1, and then if anything is in column B, you want B1=H1?

I'm gonna take a stab at it anyway.

In cell H1, enter this formula:

=IFERROR(INDEX(A1:G1,match("*",A3:G3,0)),"")

I'm not sure but wirte this in H1: if(A3="","",A1)

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.