Thread: copping data from two cells into one
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default copping data from two cells into one
Data assumed in row2 down
Try in B2: =INDEX(N:N,MATCH(LEFT(A2,2),M:M,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"confused deejay" wrote:
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.

Reply With QuoteReply With Quote