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.

--
deejay

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:

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.

--
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
--
deejay


"Stefi" wrote:

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:

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.

--
deejay

You are welcome! Thanks for the feedback!
Stefi

€žconfused deejay€� ezt Ã*rta:

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
--
deejay


"Stefi" wrote:

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:

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.

--
deejay