Multiple What if statements

[ramosca]

Hi I'm hoping you can help me with this formula. I have a worksheet with number of records.
Column C = Manhattan
Column D = Bronx
Column E = Westchester
Column F = Brooklyn
Column G = Queens
Column H = Staten Island

With each record only one boro is selected by placing an "X" in the appropriate column. for example if there is an X under Manhattan then the rest of the boros are blank.

Now a new column is to be added labeled Boro.
If there is an X under Manhattan then the result to the column added should be Manhattan.
If there is an X under Bronx then the result to the Boro column should be Bronx and so on.

Is there any formula for this scenerio? Again thanks so much for your help.

 

[CharlesChuckieCharles]

put this in the Boro column

=LOOKUP("X",$C$2:$H$2,$C$1:$H$1)

 

[ramosca]

Thanks so much. Works perfectly!!