Actually there is a problem in the attached excel sheet, here we are comparing two excel columns Number1 & Number2 . If the Number in both the columns i.e, Number 1 & Number2 is same then it will print the matching data from Sequence column i.e Column C in Final Sequence column i.e, Column D only. But in case if doesnt find the matching numbers, like in our example: Cell A5 is not matching with Cell B5, then it should go to cell B6 to find match & then print the matched sequence in red marked cel of column D.
Same is the scenario in case of cell A7 & B7. Here it will find the match in cell B9 and thus substitute the corresponding Sequence from cell C9 in cell D7.
Bookmarks