Make them work on the Each cell Value
=LOOKUP(LEFT(A2),D1:E8)
Did you actually try that formula?
I suggest you slow down and try to provide accurate solutions rather than
just posting as many replies as you can. Quality beats quantity every time.
--
Biff
Microsoft Excel MVP
"Shane Devenshire" wrote in
message ...
Hi,
Make a table with 1 throught 8 in the first column and the words you want
in
the second column. Say you do this in D1:E8
then use the formula
=LOOKUP(LEFT(A2),D1:E8)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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.
|