Use an array formula to perform a two or more criteria lookup in Excel

Hi There,
I hope someone can help me to solve my problem

I have the attached my worksheet (Master database) & LC monitoring workbook.

I'm trying to create a formula in "LC monitoring" that look up for invoice no and invoice amount which match "LC number".

How can I do this?