Geting user input and calling information based on it from google sheets

i want to get a specific number/name from a google sheet and i want all the information that comes with it to be included, how do i do this? thanks in advance!

Did you searched in community?
See Results for searching Google Sheets


You could also use a simple Givz Query