Hello Experts,
I have a case, where I have to match column from two sheets, if True, need to copy the cell value corresponding to the iterating column and paste into another sheet at column1.
For example:
Sheet 1 Sheet 2
Column2 column3 Column1 Column2 Column3
xyz abc xyz abc 789456
zxy cbc zxy cbc 789455
123 123 123 123 789440
As per example, Need to check the value in sheet 1 & 2 comparing column 1,2 if sheet 2 with sheet 1 column 2 & 3. if matched then From Sheet2 column3 value corresponding to the iterating index should copy and paste in sheet 1’s column 1