Forum Discussion
learner03
Post Partisan
Post PartisanComparing 2 sheets and output in the report
I want to compare data of Table 1 to Table 2 and based on the comparision, I want the output . Table 1 is the main table and has all the fields populated. Table 2 will have some fields missing f...
amitchandak
Super User
Super User
learner03amitchandak Sorry to mention that Number of Columns in both the tables are not same and the "if condition" to check which line to to selected from Table 2 will be based on the following columns only and not other columns-
Inner Qty Outer Qty Inner Length Inner Width Inner Height Inner Weight Avg. Carton Weight Outer Width Outer Height Outer length