Problem with Alpha Numeric Values

[Bahram]

I have large number of Alpha-numeric values in which i need to lookup other values. For example, the values are sorted from A1A - A1D - How would I make excel to find the value of A1B which is within the range given. Below i Have a sample of the data: Your help is very much appreciated.

ORG BEGIN	ORIGIN END	DEST BEGIN (3-digit)	DEST END (3-digit)	ZONE	SURCHG
A0A	A0J	A0A	A0O	6	2
A0A	A0J	A0P	A0Z	6	3
A0A	A0J	A1A	A1N	6	0
A0A	A0J	A1O	A2U	6	2
A0A	A0J	A2V	A2V	6	3
A0A	A0J	A2W	A9Z	6	2
A0A	A0J	B0A	B0E	6	0
A0A	A0J	B0F	B0R	5	0
A0A	A0J	B0S	B0S	4	0
A0A	A0J	B0T	B0Z	6	0
A0A	A0J	B1A	B2A	4	0
A0A	A0J	B2B	B2F	5	0
A0A	A0J	B2G	B4Z	4	0

<colgroup><col><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

What is the result for the sample you posted?

 

[Bahram]

What is the result for the sample you posted?

Hi -

The alpha numeric values are postal codes .. so I want to type a postal code and expect excel to I've me the zone assigned to it - if this helps

 

[Aladin Akyurek]

Hi -

The alpha numeric values are postal codes .. so I want to type a postal code and expect excel to I've me the zone assigned to it - if this helps

And what is the result for A1B?

 

[Peter_SSs]

.. so I want to type a postal code and expect excel to I've me the zone assigned to it ..

.. and also, how would we know if you've typed a destination postcode or an origin postcode?