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