So many variations......

[O177812]

I have a chart that contains the following

A	B	C
The clay can sometimes be heated to 500°F in the oven	500°F
Sometimes I can apply heat as high as 400°F to the clay	500°F
You can heat the clay above 350°F in the oven	No Rating
The clay is not heat safe	500°F

<tbody>
</tbody>

I need to do the following:
- Extract the number from Column A if it matches what is in column B then use the Value from Column B into Column C
- Extract the number from Column A if it doesn't what is in Column B then enter "ERROR" into Column C
- If Column A has a temperature and Column B contains a phrase then enter "ERROR" into column C
- If Column A contains the specific phrase "Not heat Safe" and there is a value in Column B then Enter "ERROR" in Column C
- If none of these apply then enter the Value of Column B into Column C

Help!

 

[cyrilbrd]

Hi, like this?

Excel 2013
	A	B	C
1	The clay can sometimes be heated to 500F in the oven	500F	500F
2	Sometimes I can apply heat as high as 400F to the clay	500F	ERROR
3	You can heat the clay above 350F in the oven	No Rating	ERROR
4	The clay is not heat safe	500F	ERROR
5	The clay is not heat safe		not heat safe
O177812

Cell Formulas
Range	Formula
C1	{=IF(AND(ISBLANK(B1),(ISNUMBER(SEARCH("not heat safe",A1)))),"not heat safe",IF(TEXT(MAX(0+IF(ISNUMBER(0+MID(A1,ROW(INDIRECT("A1:A"&LEN(A1)-4)),4)),MID(A1,ROW(INDIRECT("A1:A"&LEN(A1)-4)),4),0)),"000°F")=B1,B1,"ERROR"))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[István Hirsch]

Not exactly what you wanted, this formula shows „ERROR” if the string in col A does not contain any number (instead of searching for „Not heat safe”). Enter into C1 and copy down:

=CHOOSE(ROUNDUP((((ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},A1))*5+ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},B1)))+(2*COUNTIF(A1,"*"&B1&"*")))-0,6)/2,3,0),"ERROR","ERROR","ERROR",B1)

Excel Workbook
	A	B	C
1	The clay can sometimes be heated to 500F in the oven	500F	500F
2	Sometimes I can apply heat as high as 400F to the clay	500F	ERROR
3	You can heat the clay above 350F in the oven	No Rating	ERROR
4	The clay is not heat safe	500F	ERROR
Sheet

 

[O177812]

I replaced the sample information with my information and I am reciving an error for all records.

=IF(AND(ISBLANK(VLOOKUP(VALUE(A8),'S:\Ecommerce Sales\New Items\New Items Set-up\[Salsify Export.xlsx]Sheet1'!$1:$1048576,265,FALSE)),(ISNUMBER(SEARCH("heat safe",V8)))),"heat safe",IF(TEXT(MAX(0+IF(ISNUMBER(0+MID(V8,ROW(INDIRECT("A1:A"&LEN(V8)-4)),4)),MID(V8,ROW(INDIRECT("A1:A"&LEN(V8)-4)),4),0)),"000°F")=VLOOKUP(VALUE(A8),'S:\Ecommerce Sales\New Items\New Items Set-up\[Salsify Export.xlsx]Sheet1'!$1:$1048576,265,FALSE),VLOOKUP(VALUE(A8),'S:\Ecommerce Sales\New Items\New Items Set-up\[Salsify Export.xlsx]Sheet1'!$1:$1048576,265,FALSE),"ERROR"))

Do you know what would be incorrect? Was i supposed to trade out the "A1:A"?

 

[cyrilbrd]

Are the data set into two different worksheet? Hence Column B in my sample is actually into a different sheet?

 

[O177812]

Yes. I would be using a Vlookup to pull in the data.

 

[cyrilbrd]

I do not understand the range of your vlookup, Sheet1'!$1:$1048576 then you make reference to the 265th Column, what is in sheet1?