duplicate values IF

[The Grim Discovery]

	A	B	C	D
1	United	Red
2	United
3	City	Blue
4	United
5	City
6	Spurs	White
7	Spurs

<tbody>
</tbody>

Hiya

How do I get Col B to cells to populate with "Red" if the cell in Col A is 'United'? Likewise City in B5 should populate as "Blue"; and B7 should equal "White".

Thanks

 

[KennyGreens]

Hi there, try this:

=IF(A1="United", "Red", IF(A1="City", "Blue", IF(A1="Spurs", "White", "")))

 

[AlanY]

try this in B1 and copy down

=IF(COUNTIF($A$1:A1,A1)=1,LOOKUP(A1,{"City","Spur","United"},{"Blue","White","Red"}),"")

 

[The Grim Discovery]

thanks for your support both in answering my query- just realized it's a bit more complicated than I described. Have started a new thread.