Find and Replace Strings

[Dave_Holland]

Hi All,

I'm trying to carry out a find and replace type function with a table of postcodes and internal company identifier codes. Basically I would like the user to be able to type in the postcode in a workbook (rather than using ctrl+F and then manually doing it) and then in the next column along it auto-populates the internal identifier. The sample table is below, the table I imagine would have to be located somewhere in the workbook?

I would greatly appreciate any help as so far as simple '=FIND' '=SEARCH' of course don't work.

Thanks in advance

Dave

AB1 1	73
AB1 2	72
AB1 4	73
AB1 5	73
AB1 6	73
AB1 8	73
AB10	72
AB10 1	73
AB10 2	73
AB10 6	73

<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>


</tbody>

 

[konew1]

With your data in A1:b10, and the code you want to lookup in E3

=INDEX(B1:B10,MATCH(E3,A1:A10,0))