lookup 3 criteria

[yudha]

1. What is the VBA formula for obtaining "KodeParcel" (columns B6 and B7) in the "Detail Pembelian" sheet with three criteria (by "JenisBatu", "KategoriBatu" and "Ukuran") in the "Master Size Parcel" sheet?

2. How to get "TotalJumlah" in "Detail Pembelian" sheet with 3 criteria?

Range("D" & c.Row).Value = VBA.Round((Range("E" & c.Row).Value / (Application.WorksheetFunction.SumIfs(Worksheets("Master Ukuran Parcel").Range("D:D"), _
Worksheets("Master Ukuran Parcel").Range("A:A"), Range("B" & c.Row).Value, _
Worksheets("Master Ukuran Parcel").Range("C:C"), Range("C" & c.Row).Value))))

Thank you

 

[Chihiro]

So exactly what calculation do you need to do and exactly where should result be populated?

I don't understand what you are after.

 

[Marc L]

The same on my side, totally very unclear ! …​