Pull data from the sheet with reference to a column with several numbers

Don’t have empty rows or colu, as it 2ill disturb the result or you will feel harder to parse the result.

If you want to search by col then better try some paid extension

Or try this script code

For more ref here