Returning Data from Column E if Conditions in A and D are Met

[ISI_Med]

Hello Everyone,

I'm trying to create a macro that will allow me to drop information from a CSV file into sheet 'Export' and pull the required information to the 'Summary' sheet.

Ideally the macro would look in Column A and Column D and return the value in Column E on the 'Export' sheet to the 'Summary' sheet.

For instance, in the 'Export' sheet if A8 reads "South" and D8 reads "Hoax" the value in E10 ("4") should appear in B3 on the 'Summary' sheet.

Any help you can give would be greatly appreciated! I've been kicking this problem around for three days.

Thanks.