Make them work on the Each cell Value
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Steved" wrote in message
...
Hello T.Valko
Thankyou, There was a 3 "Papakura" but we sold the land, hence moved the
business to 4 "Wiri"
Thankyou.
Steved
"T. Valko" wrote:
Create a 2 column table like this:
........E........F
1.....1.....City
2.....2.....Roskill
3.....4.....Wiri
4.....5.....Shore
5.....6.....Orewa
6.....7.....Swanson
7.....8.....Panmure
Then use a formula like this:
A1 = 5845
=IF(COUNTIF(E1:E7,LEFT(A1)),VLOOKUP(--LEFT(A1),E1:F7,2,0),"")
I notice you're missing a condition for number 3?
--
Biff
Microsoft Excel MVP
"Steved" wrote in message
...
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.
|