Returning text from one of several columns

 Jen -
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 replies

Registration date
Sunday August 9, 2009
Last seen
April 20, 2010
use this formula in D1,D2.....Dn
=A1 & B1 & C1
It works! Thanks SO MUCH for your help!!