Dear All,

The vlookup formula slows down my PC . Is there any index formula for instead of below mentioned.

=IF(ISNA((VLOOKUP(A6,DATA!C:E,2,FALSE))+((VLOOKUP(A6,DATA!C:E,3,FALSE))*F5)),0,(VLOOKUP(A6,DATA!C:E,2,FALSE))+((VLOOKUP(A6,DATA!C:E,3,FALSE))*F5))

Thanks in advance.