Lookup in columns and return if the condition is match

[Dumy]

Search columns 1,2 and 3 and returns the result to all the data from column A to have a higher or lower number in Column3
Looking numerical line I need to find results that are within the allowable values

I want to search a range of data and return the name if the value inside of a specific value.
The rest of the problems I'm handling the VLOOKUP function
I need a formula that will return the names that meet the requirement. If necessary we can also add an extra help column.
If I am in cell G3 or K3 enter another number then the result should be adapted to the number of basic data

Can someone help me, my example was added to the post,
I need formula for cells G3:G11 and K3:K11