Dear Expert,

I am trying to extract a price by lookup formula but it is taking time in calculation when I am using this formula into macro. Is there any alternative formula or code available to get the same result?
Please suggest or help on this.

Thank you in advance.

Formula for which i need a macro is:
=LOOKUP(2,1/(('Price List'!B:B='Act Data Process'!E2)*('Price List'!H:H<='Act Data Process'!I2)),'Price List'!G:G)