I Have question here, I have 2 excel file one with “Receipt Type”, " Bill No." and “Amount”, and other is “Bill No.”, “Amount AR”, “Amount other AR”. I want to check if Bill No. is AR then fill Amount AR. If not AR fill Amount Other AR.Here is example
Please help me to process it !