Raw data I want to query:
I want to query this data based on an input value that could feature in any of the columns of data to then return the correct rows of data:
For example if I type in 'A001' as the ID the result will return that row of data with headings, the same as if I typed in 'Desk 1' into my search box:
The challenge I am having is that I can query only against a single column of data rather than across all - help is much appreciated!
=query('RAW ASSET DATA'!A1:D,"SELECT * WHERE LOWER(A) LIKE LOWER(""%"&B2&"%"")",1)