Solved

to return data from two cells in excel

Posted on 2013-01-03
13
227 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
 

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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
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.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now