=ARRAYFORMULA({
QUERY(order,"select * where A ='" & 'ใบแจ้งหนี้'!F12 & "'",1),
VLOOKUP(QUERY(order,"select C where A ='" & 'ใบแจ้งหนี้'!F12 & "'",1),customer,2),
VLOOKUP(QUERY(order,"select C where A ='" & 'ใบแจ้งหนี้'!F12 & "'",1),customer,3),
VLOOKUP(QUERY(order,"select C where A ='" & 'ใบแจ้งหนี้'!F12 & "'",1),customer,4),
vLOOKUP(QuERY(order,"select C where A ='" & 'ใบแจ้งหนี้'!F12 & "'",1),address,2)
})