Solved

to return data from two cells in excel

Posted on 2013-01-03
13
232 Views
Last Modified: 2013-09-21
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
0
Comment
Question by:tinatoms
  • 5
  • 4
  • 2
13 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 38739521
Can you explain it better?
0
 
LVL 23

Expert Comment

by:Michael74
ID: 38739527
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
0
 

Author Comment

by:tinatoms
ID: 38739555
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
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:tinatoms
ID: 38739565
thanks Michael, but where cell H is blank and J has something it leaves it blank still
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 38739569
But you want to fill the cell H if it's blank with the values of the cell J?
0
 

Author Comment

by:tinatoms
ID: 38739577
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
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 38739582
If I understood you could do that using a formula:

=IF(J1<>"";J1;H1)

It checks if the value in J1 is not empty and it shows the J1 or the H1. You could repeate that for several rows.
0
 

Author Comment

by:tinatoms
ID: 38739618
Jpaulino it doesnt like that think its the ""
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 38739630
Check the example
Book1.xlsx
0
 
LVL 23

Expert Comment

by:Michael74
ID: 38739658
tinatoms

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

Michael
0
 

Author Comment

by:tinatoms
ID: 38739673
Jpaulino many thanks all working now
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question