Friend
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
