Text in Cell Based Upon Text in Another Cell

[heaterengineer]

I would like one cell in my worksheet to display a specific text based upon the users pull down choices in anothe cell. There is the potential for 100 cells to contain the required input data.

Example:

If cell A1 contains Red I would like B1 to show Red
If cell A1 contains Red and A2 contains White I would like B1 to show White
If cell A1, contains Red, A2 contains White and A3 contains Blue I would like B1 to Show Blue.

Thanks for the help!

[NBVC]

Maybe:

=LOOKUP(REPT("z",255),A:A)

This returns last text entry in column A