Excel Macro Bin# return

Job help; Need to extract bin# value and if not found then an empty cell must be displayed. If there are 2 bin#'s are found both most be returned. ( 2 would be the maximum) If no bin# is found then an empty cell must be displayed! I tried to fix the issue looking for the " = " charactor and then written my formulas in column " My formula 1 " + " My formula 2 " I prefer if it could be written all in one cell if possible so! In scenario 1 I have no problem , also no issue in scenario 2 The trouble starts if only one ( or none at all ) bin# ( = ) is found then i get the error " #VALUE!" Like I said I prefer one cell formula if possible, or a visual basic routine as a MACRO WOULD ALSO BE FINE IF THAT IS THE ONLY WAY to write this. IN ROW 20 thru 28 and under Column "C" is the desired results (in a green cell ) I would like to have....