Background ....
$G$1 = a list
$L$6 = =CONCATENATE(RIGHT(E1,2)," Q")
$M$6 = A7:K78
$N$6 = =CONCATENATE("'",L6,"'",M6)

I built a formula with the concatenate function:

=CONCATENATE("=VLOOKUP(G1,",N6,",2,FALSE)")

That produces the desired formula:

=VLOOKUP(G1,'AG Q'!A7:K78,2,FALSE)

But, that output function does not calculate unless I go into the cell and
F2 F9.

Is there a way to have Excel perform that function automatically?
--
Matt