Index formula instead of VLookup

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.

The nice thing about testing for errors, that you only need to test for what causes the error.
You don't need to test the whole formula..
What causes N/A in a vlookup is the value in A6 not being found in column C.
So you can do this

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

Now, I would further recommend limiting the ranges to specific rows instead of entire columns.
=IF(ISNA(MATCH(A6,DATA!C1:C100,0)),0,(VLOOKUP(A6,DATA!C1:E100,2,FALSE))+((VLOOKUP(A6,DATA!C1:E100,3,FALSE))*F5))

Originally Posted by Jonmo1

The nice thing about testing for errors, that you only need to test for what causes the error.
You don't need to test the whole formula..
What causes N/A in a vlookup is the value in A6 not being found in column C.
So you can do this

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

Now, I would further recommend limiting the ranges to specific rows instead of entire columns.
=IF(ISNA(MATCH(A6,DATA!C1:C100,0)),0,(VLOOKUP(A6,DATA!C1:E100,2,FALSE))+((VLOOKUP(A6,DATA!C1:E100,3,FALSE))*F5))

Thanks Jonmo1, but the thing is my excel takes too much time to open and save. It has 2.82mb size only.... is there any other reason.

P.S. I removed all the formatting from workbook.