Adding info from one cell OR if that cell it's empty, from another

**la_techie** · 04-03-2012, 02:56 PM

So, I am compiling a report that has similar information on for example, column A and B.

Here's what I am trying to do:
In a separate column, gather the data from column A and if Column A is empty, gather the data from column B.

Please let me know if you need any more examples.

Can anyone help me?

Thank you,

Thx!!

**Spencer101** · 04-03-2012, 03:45 PM

Hi,

If I've understood what you mean correctly, then =IF(A2="",B2,A2) should do the trick.

**la_techie** · 04-03-2012, 04:05 PM

Thank you Spencer101. I tried what you suggested and it doesn't seem to work.
I added a picture here with an example:

Basically I need to pull data from column B and if that column is empty, gather the data from column A but not the data from A & B together...I hope this clarifies and thank you again.

Sample.jpg

**la_techie** · 04-03-2012, 04:06 PM

Thank you Spencer101. I tried what you suggested and it doesn't seem to work.
I added a picture here with an example:

Basically I need to pull data from column B onto Column C and if column B is empty, gather the data from column A but not the data from A & B together...Also you'll see from the sample that the information is words not number,s if that makes a difference.

I hope this clarifies and thank you again.

Attachment 148618

**Spencer101** · 04-03-2012, 04:16 PM

How about flipping it around to =IF(B2="",A2,B2) ?
Does that do what you need or am I missing the point completely?

I just tried it using the sample data you provided and it works for me.

Only thing is it would give you a zero if both A & B are blank.

You can get around that if you need to....

**la_techie** · 04-03-2012, 04:37 PM

Thk u so much, that formula puts a "0" on column C, the one I want to fill with data.
I need to put the data from B onto C and in case B has nothing in it, put the data from A onto C. By "data" I mean the words

Thx!!!

**Spencer101** · 04-03-2012, 04:44 PM

Any chance you could send a snapshot of what you want it to look like?

**Fotis1991** · 04-03-2012, 04:46 PM

...Or enen better, upload a sample workbook. Not a picture.

**la_techie** · 04-03-2012, 04:55 PM

Thank you guys, here you go.I hope this helps.

Sample.xlsx

**Spencer101** · 04-03-2012, 05:01 PM

Like this?

I've added another bit to the formula so you don't get a zero if both A & B are blank (i.e. row 13).

Let us know if this isn't what you want.

Sample(1).xlsx

**la_techie** · 04-03-2012, 05:20 PM

Well that worked! You people are geniuses...Just in time for my deadline. Thank you SO much you both!!!

**Spencer101** · 04-03-2012, 05:25 PM

Not a problem

Adding info from one cell OR if that cell it's empty, from another

LinkBack

Thread Tools

Rate This Thread

Display

Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Re: Adding info from one cell OR if that cell it's empty, from another

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions