Returning text from one of several columns

Closed
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!!

2 responses

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
0
It works! Thanks SO MUCH for your help!!
0