Cell formula based on finding an index on another sheet
So match() will do this.
MATCH() has three arguments:
Search_for : the sku you want to check from col N sheet 1
Search_where : column B on sheet 2
type of match : need 0 for exact match
Not built an example as your data is in images.