input.xlsx (9.3 KB)
outputdata.xlsx (8.4 KB)
@MohammedShabbir could you help me with one more query where i need to check the combination of parent and subacc from sheet 1 and if that combination is there then we can add match else mismatch like in output sheet but data to be populated on sheet1 column D