Trying to create an "if" formula in Excel which will include wildcard characters. Example:-
cell a1 contents are B-YRH 15
cell a2 BL-YRH
cell a3 CA-NRH
cells b1:b3 contain numerical values
I want cells c1:c3 to search by wildard for the characters before, or after, the hyphen in a1:a3 (eg *-YRH ) and show the numeric values from b1:b3 as appropriate. Whichever wildcard operater I use the result is always shown as "false" (but not as a formula error). Can anyone help please ?