Hi,
I have two sheets - that contain album artist/track name data and one of the sheets also contains a billboard chart number. I want to compare the data on sheet 1 - columns are Artist/Title - with sheet 2 columns Artist/Title - if there is a match I want to copy data Chart from sheet 2 (which is in the 3rd column on sheet 2) to Chart Column o(third column) n sheet 1. Hopefully this makes sense.
Sheet 1
Artist/Title/Chart (all chart data currently blank)
Sheet 2
Artist/Title/Chart
If Artist/Title match on both sheets - copy chart data from sheet 2 to chart column on sheet 1 in matching spot.
If this can be done easily I may want to be able to copy two or three columns from sheet 2 if Artist and Title match - so if directions for this could be provided that would be great.
Thanks in advance.
Bookmarks