I have a chart that contains the following
<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!
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!