Need VBA to validate billing status only cancel and reject against order and category

[julielara]

Dear experts

I have masterdata L&T column, i have lookup values data in A:D i want validation from lookup into masterdata get result E&F

i want do validate through 3 way lookup, if Order ID and Category match and check if task is Invoiced, check any another rest of task with

If Task(O:O) end with TDO ,TDO(1),(2),... or SDO(1),(2),(3)..and ,if Invoice column(Q:Q) = Billed and If Invoice column (R:R) =Cancelled or Rejected and If Field Officer(F) then take this combination against lookup value column F:F and mark as Valid in E:E, other wise Invalid.

for e.g
Order = 13899 there is 2 task item, first LOB status is billed, second line item Billed but cancelled, so take second item as valid for blling.
another example
Order = 50459 there is 3 taskitem in masterdata, first task invalid and second and third is billed and cancelled or rejected so take 2,3 combination into cell.

find the attachment

[julielara]

any experts help on this?