I am looking for a formula to return values from cells in a range if the lookup_value is >= one number and <= another number. The lookup_number will fall between these criteria a few times.
I've seen Index and Small used, but only where one criteria is used.
I have attached a file with a sample, it should make my question clear.
Thx
Bookmarks