Search Cell for unique number from range

[parttime_guy]

Hi,

I have a column which has alphanumeric characters...

Task to be done
Find/Search the cell for unique number from a Data range and give results.

Problem
If the cell contains only numbers the MATCH function is working
But... if the cell contains alphanumeric characters the formula shows an error :dunno

Attached is a sample file.
Kindly Help :help : pray2:

Best Regards

[Bob Phillips]

Try

=MATCH(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99),$D$1:$D$928,0)

[parttime_guy]

Dear XLD,

Thx for the quick reply. Ur formula worked in most cells.

The thing is that - Iam trying to extract the matched PIN/ZIP code from an address. The PIN/ZIP could appear mostly either at the end of an address (or the second last line, well I would'nt know the exact postion of the PIN/ZIP codes)

Now the only problem is when an address contains the PIN/ZIP and extra info other than the PIN/ZIP codes eg. Road Number, Floor, Bldg No etc - well then the formula goes for a toss

Any ideas how do I overcome this situation?

But in any case I shall use ur formula.

Best regards :friends: :bow: