Dave_Holland
New Member
- Joined
- Apr 10, 2014
- Messages
- 2
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
<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>
</tbody>
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>