COPY DATA FROM 2 CELLS

C

confused deejay

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

A (this is pasted in from another sheet) B (is where i want the answer)
cc1 1cc 9
aa2 2aa 7
bb3 3bb 8

column M(has the full list of postcodes) N (code relating to postcode in M)
aa2 2aa 7
bb3 3bb 8
cc1 1cc 9

the list in column A can be in any order and needs to find the correct code
and place it in column B

one code that has half worked is... in B2: =INDEX(N:N,MATCH(LEFT(A2,2),M:M,0))
but that was only using the first 2 letters of the postcode, i need the
whole postcode as cc1=9 cc2=4 etc.
 
S

Stefi

Simply omit LEFT from the formula:
=INDEX(N:N,MATCH(A2,M:M,0))

or
=VLOOKUP(A1,M:N,2,FALSE)

Regards,
Stefi

„confused deejay†ezt írta:
 
C

confused deejay

thank you so so much i've been racking my brains for hours and hours tried
everythin i could think off.

thank you again my friend
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„confused deejay†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of sub groups 3
Finding the right style field in VBA 0
Macro to download house prices from web 0
copping data from two cells into one 3
Data Validation List (conditional) 2
Code to insert a coma 26
Finding Next Largest Number Based on Criteria 3
Array with many cells from a row but not in order or together 11

Top