I have two spreadsheets- spreadsheet 1 has 1600 rows with 12+ columns of data. Spreadsheet 2 has 150 rows with only 3 columns of data.The first column on each spreadsheet contains a client ID. I am looking to “query” spreadsheet 1 for the data I need for the 150 clients in spreadsheet 2. How can I do this?
Essentially, I want to create a third spreadsheet that has 150 rows (the 150 clients I am looking for more info on) that has all 15+ columns of data from both spreadsheets matched to each client. I can’t share the sheets as it has private info in it. Thanks!
Essentially, I want to create a third spreadsheet that has 150 rows (the 150 clients I am looking for more info on) that has all 15+ columns of data from both spreadsheets matched to each client. I can’t share the sheets as it has private info in it. Thanks!