VLookup or any other lookup to populate data

Hello:

I am trying to populate data from one sheet to another to create invoice for the customer.

Please refer to attached excel sheet.

Sheet 1 has all invoicing information. Invoice # is in column D
(The data between 7000 and 7001 in column D is the data for Inv # 7000)

Sheet 2 is the where i need a data for particular invoice.

I will have Invoice # in Cell F7 in sheet2

I need a formula (VLOOKUP or some other) to populate the the related invoice information to be pasted in Cell C19.

I have manually pasted Invoice # 7000 related information from sheet1 to sheet2

Please help me with the formula to do this by looking up the invoice # in Cell F7.

Thanks and let me know if any questions.

Riz