I solved this by using the “Enter Manually” Search Method option. I then dynamically referenced the spreadsheet ID and the sheet name that I calculated in earlier steps.
1 Like
I solved this by using the “Enter Manually” Search Method option. I then dynamically referenced the spreadsheet ID and the sheet name that I calculated in earlier steps.