1 will be City, 2 will be Roskill and so on please.

S

Steved

Hello from Steved

Numbers 1234, 1543, 1674, 1896 A formula please to use 1st digit to be
identifier
which in this case is 1 so will return the value City

Numbers 2234, 2543, 2674, 2896 A formula please to use 1st digit to be
identifier
which in this case is 2 so will return the value Roskill

Thankyou.
 
M

Max

One way ..

Assuming you have set-up the reference table
in Sheet1, cols A & B, from row1 down as:

1 City
2 Roskill
etc

Then in another sheet, say, Sheet2, if the numbers:
1234, 1543, 1674, 2234, 2543, 2674 etc are in A1 down,
we could put in say, B1:

=IF(A1="","",IF(ISNA(MATCH(LEFT(TRIM(A1))+0,Sheet1!A:A,0)),"No
match",VLOOKUP(LEFT(TRIM(A1))+0,Sheet1!A:B,2,0)))

and copy B1 down

Col B will return the desired results

Unmatched cases, if any, will return the phrase: No match
 
S

Steved

Hello Max from Steved

This is just what I am requiring as I have over 10 Cities and your good
formula will do the job nicely

I thankyou for your time on my issue.
 
Top