It is a litle bit complicated, but I'll try to explain
It's all about discount (%)
I've got 15 conditions.
Cell D1 is costumer
Range("B15:B39) are diferent Codes of products
Now let's start
If(Vlookup(B15;Šifre!B2:G65535;6)="P";If(Vlookup(B15;Kupci!B2:M65535;12)="I";KOEFICIJENTI!D12))))
there are letters that specify tipe of article:
P
D
Š4
R3
K
and tipe of costumer:
I
R
E
All together 15 conditions.
Every product has a diferent discount depending of costumer.
Until now 25000 products, and 700 costumers.
Or to resolve problem with a macro?
Something based on folowing:
Dim fn As WorksheetFunction, LookupVal As Variant
Set fn = WorksheetFunction
On Error Resume Next
If fn.VLookup(Sheets("Radno").Range("B15"), Sheets("Šifre").Range("b:g"), 6, False)="P" And
If fn.VLookup(Sheets("Radno").Range("D1"), Sheets("Kupci").Range("b:m"), 12, False) = "I" Then
Sheets("Radno").Range("F15") = Sheets("KOEFICIENTI").Range("D12")
Hope U've understood me.
THNX