Current location - Training Enrollment Network - Mathematics courses - How to use the data comparison formula in two worksheets of VLOOKUP to solve in EXCEL?
How to use the data comparison formula in two worksheets of VLOOKUP to solve in EXCEL?
Enter or copy and paste the following formula in I2 of Table 2.

=IF(VLOOKUP(B2, table 1! B:E, 4,)<& gtG2, "different", ")

or

=IF(VLOOKUP(B2, table 1! B:E, 4,) =G2, ","different ")

Pull-down filling