Perhaps you can check whether the value you are looking for exists in the range, and if so display yes? So something like

=IF(COUNTIF(B2:B3000,"x")>0,"yes","no")