The table is not sorted, so I'm appending "false" which I understand
should solve that problem.
Here's the primary formula:
=VLOOKUP(A2,'sheet 1'!A:F,6,FALSE)

The formula inside A2 (the lookup value) is:
=IF('sheet 2'!Q2=FALSE,TRIM('sheet 2'!A2),0)


Thanks