To check if value exists in range of another sheet, you can use the COUNTIF formula and pass the Sheet number with the range as the first parameter.