Link to home
Start Free TrialLog in
Avatar of tinatoms
tinatoms

asked on

to return data from two cells in excel

I have two cells in excel with text in one and the other is blank, i want to say if h2 cell is blank return K2 cell text and other way round too
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image

Can you explain it better?
This formula should give you what you are after
=IF(AND(ISBLANK(H2),ISBLANK(K2)),"",IF(ISBLANK(H2),K2,H2))

Open in new window


Michael
Avatar of tinatoms
tinatoms

ASKER

ok lets use A & B Cells

I have Australia in A and B is Blank so in Cell C i want it to show Austrailia

But if there is text in A & B i want to only return B text
thanks Michael, but where cell H is blank and J has something it leaves it blank still
But you want to fill the cell H if it's blank with the values of the cell J?
no ok right i have might have text in H or J  then in other cell i want to return either whats in J or if blank whats in H
ASKER CERTIFIED SOLUTION
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jpaulino it doesnt like that think its the ""
Check the example
Book1.xlsx
tinatoms

My formula looks at cells H2 and K2 as per the original question. It also allows for both cells to be empty

Michael
Jpaulino many thanks all working now