Spreadsheets - Selecting rows by column input with two digits (one number and one letter)

[naoter...@gmail.com]

Hi..

  I am having some moving spreadsheet data to a different tab, when selecting rows according to input in a certain column; this input is made of a 2 digit figure with a Capital letter and  a number (something like M3, F4, X5, etc..);

  I initially tried the template "fill-in the blank"-style with no success and changed over to "basic query" - still nothing worked;

   I've tried back-quotes, single quotes, triple double quotes with no success;  

Something like:

=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem Total'!A2:R,"Select * Where B="&B1&" "))

which worked fine for single numbers..

Then I tried this:

=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem Total'!A2:R,"Select * Where B="""&B1&""" "))

then this

=if(query('Armazem Total'!A2:R,"Select * Where B="'&B1&'" "))

and

=if(query('Armazem Total'!A2:R,"Select * Where B="`&B1&`" "))

Then simplified to:

=query(!A1:F7, "Select * where B=`2F`")

And no luck so far.

Any ideas?

             Thanks!!

                   b.