Lookup & Index

I am creating a spreadsheet for the mortgage department. I have 2 tabs, appraisal fees & construction inspection fees.

Appraisal Fees will be completed by the processor as the applications are received and fees are collected. Column E is to identify loans that are construction loans, marked with a 'Y'.

In the construction tab, I want to bring over columns C & D from appraisal fees when there is a Y in column E of appraisal fees tab. I want to index this so that it starts from the top of the construction inspection fees.

Is it as simple as adding an index function to the start of the if formula?

=if('Appraisal Fees!E2='Y'!, 'Appraisal Fees!C2:D2, "")

Thanks again, you guys are the experts....Jeff