ok so if i have data on one spreadsheet and different data on the second spreadsheet, how do I say to excel:
here is a record for Bill on spreadsheet 1 with his date of birth and here is a record for Bill on spreadsheet 2 with his address...from spreadsheet 1 go find bill on spreadsheet 2 and...