Search a cell reference and return another cell reference

Thanks for the quick reply! Hope this helps. Just a really rough example of what I am doing. That actual connection tree is far more complicated.

Chris

I'm basically trying to fill column B with the relevant data from column C.