Matching data

[lopster10]

Hi there,

I have a problem but am really unsure of which function to use to get the correct data, I have tried a number of different approaches to no avail.

The spreadsheet contains a lot of data but too try and cut it short I need to this:

I have a load of customer ID's in Col A.

In Col M I have customer ID's and Col N their expiry dates ( So essentially this data has no relation / order to Col A)

Basically what I want to do is add a new column, this being Column B. THen using the ID in Col M find this in Col A and insert their expiry date taken from Col n.

Sorry if that makes no sense, please ask if you have absolutely no idea what I mean

Any help appreciated,

Regards,

LOpster

Lopster

 

[xlbo]

you can use either VLOOKUP or a combination of INDEx/MATCH formulae

=vlookup(A2,$M$2:$N$1000,2,FALSE)

=INDEX(N;N,match(A:A,M:M,0))

should do the trick - just adjust the range reference in the vlookup if you choose that one

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[lopster10]

Thanks very much for the help. I did attempt a vlookup but must of had something wrong as yours worked perfectly,

Cheers

Lopster