Google Sheet - Lookup Spreadsheet Rows

Is there a way to increase the looked up rows (currently capped at 100). Or is there an alternative way to modify the search, so it searched starting from row 100 and subsequently (ex. row 100, 101, ...200)?

I'm afraid this limit cannot be increased; it's set from Google's end.

Thank you!