Hi All,

I have to generate a final report by comparing 4 different reports by look up command.

I need to compare A column in report-2 and D column in report-3 and display a cell value in report-3. This can be done by Look up, whereas the problem is i need to do this in a report which contains 2 lakhs rows.

Any Suggestions on this to automate