Hello I have a function as bellow.

=SUM(IF(Data!$B$2:$B$10000>=1500011001;IF(Data!$B$2:$B$10000<=1500101008;IF(Data!$A$2:$A$10000>=TOPLAMALAR!B3;IF(Data!$A$2:$A$10000<=TOPLAMALAR!C3;VLOOKUP(Data!$B$2:$B$10000;'Zafer Costs'!$A$2:$C$347;3;FALSE)*Data!$I$2:$I$10000*D3;0);0);0);0))

The problem I have is using the vlookup part:
VLOOKUP(Data!$B$2:$B$10000;'Zafer Costs'!$A$2:$C$347;3;FALSE)

After some research I can see that vlookup functions do not work with array functions, but I see that you can use *maybe* lookup or index function

What I want to do is:
1. If (from "data" sheet) B2-10000 is higher or equal to 1500011001 (this is part number)
2. If (from "data" sheet) B2-10000 is lower or equal to 1500101008 (this is part number)
3. If (from "data" sheet) A2-10000 is higher or equal to TOPLAMALAR!B3 (this is date)
4. If (from "data" sheet) A2-10000 is lower or equal to TOPLAMALAR!C3 (this is date)

Then I want to lookup the values B2-10000 and return from a table their costs (3rd column) and multiply this number by data I2-10000 and then ofcourse sum everything up...

Please help!

Bora