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


I have a sheet with I will show an image here
I want to search for a name and return a column or line with their respective values

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