Partial cell Match

[chadlaw32]

I am trying to right a formula that will look up the firs set of values in a cell where there are numbers separated by a dash below is an example of the data. I want to look up the 301 or 024. Any ideas?
[TABLE="width: 91"]
<colgroup><col></colgroup><tbody>[TR]
[TD]301-513410[/TD]
[/TR]
[TR]
[TD]303-545826[/TD]
[/TR]
[TR]
[TD]024-562515[/TD]
[/TR]
[TR]
[TD]303-556837[/TD]
[/TR]
[TR]
[TD]027-499338[/TD]
[/TR]
[TR]
[TD]303-557957[/TD]
[/TR]
[TR]
[TD]313-518514[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Get rid of column D I want to look up part of column B. 301 an 303 and 024 on your table where i have another table that says 301 is city A and 303 is city b and 024 is city C.

=VLOOKUP(LEFT(B2,FIND("-",B2)-1),Table,2,0)

The first column of Table must be text. If it is a mix of text values and true numbers, we need to tweak this formula.