so i’ve got two spreadsheets, both are lists of zipped music files on a hard drive with 4 columns in excess of 60k rows each. like so:
artist | title | serial | file location
i need to compare ONLY the first two columns of both spreadsheets, and spit out the FULL ROWS from the second spreadsheet that match the first to a third sheet so i can then use the data from the 4th column elsewhere. Is there any way to do this in Calc, and how would i go about it?
Bear in mind i can be a bit… less than bright… sometimes, so feel free to explain it as step-by step as possible.