- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 18 2017 10:10 AM

You may need to use a formula like this if your data is not exactly sorted in the identical order - this applies to cell A2 of Sheet1: use this formula and select red fill.

=IFERROR(J2>VLOOKUP(A2,Sheet2!A:J,10,FALSE),FALSE)