Hi

Hope someone can help. I have two sets of numbers that I would like to
cross reference with each other. They are parcel numbers. The first column
is the old style. The second column holds the new style. I would like to
create a form that if you input one or the other of the values it's counter
part would show up. An example below:

1559-F-1 PT SW 65-4-120-053-0510
1559-F-2 PT SW 65-4-120-053-0520
1560-F-1 E 1/2 65-4-120-054-0101
1560-F-1 PT SE 65-4-120-054-0120
1560-F-1 PT SE 65-4-120-054-0130
1560-F-2-A LOT 65-4-120-054-0200
1560-F-2-B LOT 65-4-120-054-0210
1560-F-3 PT SE 65-4-120-054-0220
1560-F PT SE 1/ 65-4-120-054-0230
1562-F PT SE 1/ 65-4-120-054-0410


Say if I entered the old parcel number of the first row as "1559-F-1" I
would like it's equivalent "65-4-120-053-0510" to show up. Or switch it
around and type in the new parcel number of "65-4-120-053-0510" and the old
number of "1559-F-1" should appear.

There are also three basic numbers that I will be using.

65-4-120-XXX-XXXX
66-4-120-XXX-XXXX
67-4-120-XXX-XXXX

Is there a way to just type in the "X" values and not have to use the whole
number or even need to type the dashes but yet still have then show up.

I have never used this site before and I may be asking for way to much. If
so please just ignore my request. I thought this would or should be fairly
simple and volunteered to do it, but now find myself scratching my head
after several hours at the attempt.

Thanks in advance for any help.

Mike