Return Valve based on Range

Hi All,

Here is my puzzle, I am using excel 2007, I have attached a sample excel spreadsheet.

I have a list of IP ranges in column G and H as low and high range and in I is the location.

What I want to do is if column B falls with the IP range of column G and H then return the location in column I into cell C2.

I hope that makes sense!!

Thanks

Hi BrokenBiscuits,

No, the IP ranges are not in order, does this change the formula?

BrokenBiscuits,

When you say in order, do you mean Column B or column G or both?