Lookup and match a number to a start and end sequence column

Hi Everyone,

I have been working on solving a problem in Excel for a couple of days and wondered if there was a quicker method to achieve the below? I have tried index and match but cannot use autofill to drag down to the rest of the values I need to check. Not sure if PowerQuery would solve this.

I have a worksheet with 2 columns: Start Sequence, and End Sequence, for instance B2 and B3 (see attached example).
In the second worksheet I have a column named: Sequence Ref with over 9000 sequence reference numbers, for example A1 (see attached example).

There are over 9000 records in each workbook (example contains 20 records).

I want Excel to lookup each value in the Sequence Ref column and match it to the relevant Start Sequence and End Sequence columns to see if it falls within the sequence range. Once matched it must either indicate the row number the sequence falls in (or any other method to indicate to the user that the match was found in the relevant start and end constraint).

If it is not found it can return "not found" or leave the answer blank.

I can use the IF, index, match etc but when dragging down the column to return the result for all sequence refs, it does not work.

Hoping someone can guide me or tell me it is not possible?

Many thanks.