All cells marked x refer to another cell

[ECUPIRATE]

This is what I have
=IF(AND(OR((Descriptions!B3="x",Descriptions!C3="x",Descriptions!D3="x"),(Descriptions!B3="",Descriptions!C3="",Descriptions!A3=""),( Descriptions!B3="",Descriptions!A3="", Descriptions!D3="x"),( Descriptions!C3="",Descriptions!A3="", Descriptions!D3="x")),(Descriptions!A3),(Descriptions!D3),(Descriptions!C3),(Descriptions!B3))))

Here's what I am trying to do:

My goal is to consolidate Descriptions on an Income Statement. I am creating a workbook where each tab references a column heading in the Descriptions tab. So, A2:J2 on Descriptions tab make up 10 different tabs in the workbook. I want a person to be able to manually mark x next to a description that is already listed, and to create a new row when there is a description that hasn't already been recorded. Then, the values would be recorded on the respective tab. I've successfully completed Tab 3 (Georgetown Shoppes) using this formula:

=IF(AND(Descriptions!C3="x",Descriptions!B3="x"),Descriptions!A3,Descriptions!C3)

....Now my worry is completing 4-10 because I have to figure out how to make a formula that will incorporate the blanks, and "x"s.

The cell that will hold the formula, will not show an x, or a blank, but just the description.

....I hope I explained Well ...Please help!

 

[ECUPIRATE]

Sorry, I tried to post a picture but couldn't figure out how to upload one on my work computer.

 

[Aladin Akyurek]

Sorry, I tried to post a picture but couldn't figure out how to upload one on my work computer.

For posting useable samples (instead of images or pictures which are not Excel readable), see http://www.mrexcel.com/forum/about-b...tachments.html. It's also better to describe a problem in words than in a non-working formula.

 

[ECUPIRATE]

Sorry about that, I created a new thread.. I'm going to scrap this quest. I think it's better to find the longest word in a range and let the cell spit that out. The new thread is here Find longest String in Range, and Reflect in Cell.