hi
i have a worksheet with postcodes on it in column A in column m i have a
list of short postcodes with a number in the adjacent column i.e

A M N
CM0 7DQ CM 89
WA12 2ER WA 01

this can be repeated several times and can be in any order.
what i need is in column B i want the matching code from column N

I thought of =IF A:A=M:M,N:N but i think this is confusing things plus its
not reconignising the part code in M. because A can be in any order and
duplicated many times its hard to add the IF to the line number.


p.s using 2003 if this helps

Thank YOU
--
deejay