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