Search number between the range

i want Cell A1 to be found from which range it is & also highlight the Row i require Excel formula for this i tried index function & match function but it wont work can you suggest easy formula for this

enter image description here