In cell c4 I enter a value. In column BD4:BD28 this same value appears in
just one of the cells. In column BE4:BE28 I have the value I want to return.
I know with the correct lookup formula I should be able to do this but I am
stumped. None of the columns need to be sorted or in any type of order.

Thanks in advance