After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves...