Extracting and comparing numbers (Complicated)

[O177812]

I have list of statements that include temperatures and a column that contains what is supposed to be the oven safe temperature:

Column A	Column B
Safety	Oven Temp
The clay is oven safe to 350°F	350°F
The clay is oven safe to 400°F	500°F

<tbody>
</tbody>

In a seperate column I need to compare the 2 temperatures and if the temperatures match then input the value in Column B, if they don't match it should enter "ERROR"

Thanks in advance for the help!

 

[MarcelBeug]

In C2 enter, and copy down

=IF(B2<>RIGHT(A2,LEN(B2)),"ERROR",B2)

Or do you need something more complicated?

 

[O177812]

Hi,

I would actually need something more complicated. I may have missrepresented this. The temperature in Column A will sometimes be in the middle of the sentence.
I would need to extract the temperature from column A and then compare.

Thanks for your help.

Have a great week!,

 

[MarcelBeug]

Try:

=IF(ISNUMBER(SEARCH("*"&B2&"*",A2)),B2,"ERROR")