Hi community,
i have two excel sheets with me in that have
using Read range i stored both in dt1 and dt2
now using filter data table iam mapping through the dt1 INVOICE_NO matched from dt2 with SHIPPING_INVOICE_NO its true and it has check other condition like QUANTITY AND Quantity
at end i have create the remarks as matched
this is my logic how to create ha workflow for it but now problem is how do i check the condition of A2 when the invoice is not availble it always will be empty becuse no of quantity may increase i don’t how much quantity i ma having and also problem is first row is matched in remarks it matched first row and again checking the invoice no which should no check the invoice no where it alreadly macthed it should go to quantity and remaining condition
please check in sheet1 in both files
boe_file.xlsx (9.6 KB)
Invoice_Format1.xlsx (9.4 KB)