Helllo Rowan from Steved

Question please
=IF(LEFT(F6)="1","City",IF(LEFT(F6)="2","Roskill", IF(LEFT(F6)="3","Papakura",IF(LEFT(F6)="4","Wiri", IF(LEFT(F6)="5","Shore",IF(LEFT(F6)="6","Orewa",IF (LEFT(F6)="7","Swanson","")))))))

I would like to add 2 more in ie
IF(LEFT(F6)="8","Panmure",IF(LEFT(F6)="9","Waiheke ",

With your formula you kindly gave me is it possible.

Thankyou.

"Rowan" wrote:

=IF(LEFT(A1)="1","City",IF(LEFT(A1)="2","Roskill", ""))

Regards
Rowan

"Steved" wrote:

Hello from Steved

I would like to please use only the first number as a identifier.

for example 1234, 1543, 1789, 1673 in this case the 1 will = City
for example 2234, 2543, 2789, 2673 in this case the 2 will = Roskill

Thankyou.