Returning text from one of several columns

Question

Returning text from one of several columns

[Closed]

Report

Jen - Aug 14, 2009 at 03:18 PM
Jen - Aug 17, 2009 at 09:52 AM

Hello,
I currently have IF Formulas in 3 columns across the page. The formulas return a blank ("") in 2 of the 3 cells in each row. I want to have one final column at the end which returns the information contained in the one cell that returns text.

For example:

      A             B            C             D
1          Red                          
2                       Green
3                                      Blue

I would want D1 to return "Red", D2 to return "Green" and D3 to return "Blue." Remember that the "blank" cells are not actually blank- they just contain formulas that are set to return a blank cell if certain conditions aren't met.

Any help would be appreciated as to how the formulas in cells D1, D2 & D3 should look to get the results I am looking for.

Thanks a bunch!!

Returning text from one of several columns
Excel if two columns match then return value third ✓ - Forum - Excel
Excel vba search column for value and return row - How-To - Excel
Comparing columns and returning value ✓ - Forum - Excel
Compare Column A to Column B and return Column C ✓ - Forum - Excel
Returning value from column b in column c, in a cell ajacent to ✓ - Forum - Excel

2 replies

Ask a question

kaiyasit · Answer 1 · 2009-08-14T22:08:45-0400

Answer 1 / 2

kaiyasit

Posts: 30
Registration date: Sunday August 9, 2009
Status: Member
Last seen: April 20, 2010

12
Aug 14, 2009 at 10:08 PM

use this formula in D1,D2.....Dn
=A1 & B1 & C1

Jen · Answer 2 · 2009-08-17T09:52:27-0400

Answer 2 / 2

Jen
Aug 17, 2009 at 09:52 AM

It works! Thanks SO MUCH for your help!!

Returning text from one of several columns

2 replies

Your reply

Subscribe To Our Newsletter!