I've been stuck on this problem for a while now, and I'm not sure if it is something that can actually be done or not. What I need to do is lookup a value (from a data validation drop down box) in two seperate locations, and if there: return the lowest corresponding value, then the next corresponding value, then the next, etc... until there are no values left in either of the locations. The problem I am having most with this formula is the ability to search both locations at the same time and having it check back and forth for the lowest value until there are no more. Anyone know if this is possible to do? I can provide a sample if necessary.