Hi
I am looking for a formula that will fill in a value from a lookup list. However, the value to lookup is to fall within a number range that is between a value in 2 columns. There is also a column for ref number. The ref number to lookup has to equal the ref number in the lookup list.
In the attached file, I am looking to populate the region in column H, from the list in columns A to D, where the ref number in column F equals the ref number in column A, and the value in column G is between the values in columns B and C. I have highlighted in red the values I want to return with a formula.
I am thinking this needs a combination of Min/Max/Index/Match but am not sure how to go about this. Please can someone help me!
Thanks
Bookmarks