Return Serial Number based on corresponding cell being blank or not

(Beginner here)

Sheet 1 has tons of data.

Sheet 1 example.

1. Column A contains Names


2. Column B contains Business


3. Column C contains State


4. Column H contains SR numbers (Will contain duplicates)


5. Column AF contains Notes

On this sheet (in column H) are the values I want to search by. There can be many duplicates of the SR numbers. I want to pull the Values from Column A, B, C, H to Sheet 2 IF the SR number (column H) has BLANK notes in column AF.

The issue is, for instance, the SR number 1234 could have multiple Entries. The SR number (1234) could have notes in one of the entries, but not in another. But, because one of the entries has notes, I do NOT want to pull any of SR 1234 entries over. I only want the data if NONE of the SR 1234 have notes.

Also, SR numbers will not always have a matching name in Column A as multiple people may make entries for it.

(I would submit an image, but I don't have enough experience on this site yet)