If Search funtion = one cell over

So I have this function I'm trying to use. Here is sample

=IF(ISNUMBER(SEARCH(C2,B2:B400)),"OK", "Not OK")

What I would like to do with it is replace the true part of the statement with a cell value relative to the found cell. So if the function finds the value of C2 in the range of B2:B400 instead of returning a value of OK it will returns the value of the cell to the right of the one where the value was found in the range.

Is that possible?

Thanks.

-Mogul

=IFERROR(VLOOKUP(C2,$B$2:$C$400,2,0),"") is what you will need.

This looks at the 1st column of the range B2:C400 to see if a match is found to C2. If it is it returns the 2nd column (i.s the value in C). The 0 in the formula tells excel to only return a result when an exact match is found. The iferror will leave the cell blank should there be no match (if there is not match and no iferror the result would be an error).