=VLOOKUP(LEFT(A2)+0,{1,"City";2,"Roskill";4,"Wiri" ;5,"Shore";6,"Orewa";7,"Swanson";8,"Panmure"},2,)



"Steved" wrote:

Hello from Steved

in Cell A1 I have 5854, now picking up the first digit which is 5 it will
type in "Shore"

Please how do I ask the bottom Formulas to do this please
=IF(LEFT(A2,1)="1","City","")+=IF(LEFT(A2,1)="2"," Roskill","") as this method
leaves me a true or false .

=IF(LEFT(A2,1)="1","City","")
=IF(LEFT(A2,1)="2","Roskill","")
=IF(LEFT(A2,1)="4","Wiri","")
=IF(LEFT(A2,1)="5","Shore","")
=IF(LEFT(A2,1)="6","Orewa","")
=IF(LEFT(A2,1)="7","Swanson","")
=IF(LEFT(A2,1)="8","Panmure","")

Thankyou.