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

Try...

=VLOOKUP(C4,$BD$4:$BE$28,2,0)

Hope this helps!

In article ,
"scott45" wrote:

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