Solved

to return data from two cells in excel

Posted on 2013-01-03
13
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
13 Comments
 
LVL 48

Expert Comment

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

Expert Comment

by:Michael Fowler
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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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:Michael Fowler
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

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

617 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