I have a Sheet1 that I want to use as my dataset for a Google Spreadsheet query that looks as follows:
The query is in Sheet 2 and I want to pull across a list of manufacturers who have a Type that matches the value in Sheet2:A1. The query I currently have isn't working but I can't see what I'm doing wrong.
The value in Sheet2!A1 was copy and pasted from Sheet1!C4 so should be identical.
Spreadsheet can be found at https://docs.google.com/spreadsheets/d/1RP5U16TMbTdZngjrJhGfJxzeLNLapOl9zScQtb2PFLE/edit?usp=sharing
Can anyone advise?