Question

[G3£wh\)zZ@]

We are two Dj`s who have recently got together to offer a better service

Both of us have a list of our record/cd collection and we have stuck them
together to create a large list.

(Artist / Song / Cd Title / Quality / Track Length)

I also have a list of the entire uk chart history

(Artist / Song / Year / Chart Position)

Is there away i could get excel to look at the two lists then if a Artist
and Song is found in both lists the Year and Chart
position is copied over from the chart list to the music list so instead of
(Artist / Song / Cd Title / Quality / Track Length) it would be
(Artist / Song / Cd Title / Quality / Track Length / Year / Chart ).


I dont know if it is possible but i do appreciate any help...


Thanks

 

[Frank Kabel]

Hi
have a look at the VLOOKUP function (see:
http://www.mvps.org/dmcritchie/excel/vlookup.htm)

 

[G3£wh\)zZ@]

Hi
have a look at the VLOOKUP function (see:
http://www.mvps.org/dmcritchie/excel/vlookup.htm)

Thanks