Google Sheets Query won't recognize Col6 or F

Caleb W. 0
Viewed 28
=QUERY({'Gudang Utama'!E3:F;'Stok Penjual'!E3:F;'Ruang Kemas'!E3:F};"select Col6 where Col5 matches """&C3&"""")

Above is my function. I know that using capital 'C' is necessary and that when pulling information from multiple sources, using the syntax of Col is necessary but I continue to get this error.

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col6

Help! Thanks

google-sheets-formula sql
1 Answers

use:

=QUERY({'Gudang Utama'!E3:F;'Stok Penjual'!E3:F;'Ruang Kemas'!E3:F};
 "select Col6 where Col5 matches '"&C3&"'"; )
player00
Related