I am using lookup formula for values in range to get the desired value for a lookup value, however, lookup formula fetches the value if it falls in range and if the value is not in the lookup range i want to put else condition.
I have attached the file for easy reference.
Kind assist ASAP.
